Home |
Search |
Today's Posts |
#1
|
|||
|
|||
tricky conditional formatting
Good Morning, I have a problem creating some conditional formating. And I am not sure how or if it is possible. I basically want to have a range of cells highlight with a color if the value of the cell matches any of the contents of a list. -- albritton_99 ------------------------------------------------------------------------ albritton_99's Profile: http://www.excelforum.com/member.php...o&userid=16139 View this thread: http://www.excelforum.com/showthread...hreadid=276569 |
#2
|
|||
|
|||
I'm not clear as to what you're looking for, but if you want any cell in your range of data highlighted if it matches a list... 1) Select your data 2) Format Conditional Formatting Formula Is 3) Enter the following formula: =MATCH(A1,$F$1:$F$5,0) 4) Choose your formatting 5) Click OK ...where A1 refers to the first cell in your range, and F1:F5 contains the list to match. On the other hand, if you want to highlight the whole row if the value in Column A matches your list, then change the above formula to... =MATCH($A1,$F$1:$F$5,0) Hope this helps! -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=276569 |
#3
|
|||
|
|||
Hi
lets assume the following: - your range is A1:B5 - the cell to check is cell B1 - your list is in C1:C5 Now try: - select A1:B5 - goto the conditional format dialog and enter the following formula =COUNTIF($C$1:$C$5,$B$1)0 - choose your format "albritton_99" wrote: Good Morning, I have a problem creating some conditional formating. And I am not sure how or if it is possible. I basically want to have a range of cells highlight with a color if the value of the cell matches any of the contents of a list. -- albritton_99 ------------------------------------------------------------------------ albritton_99's Profile: http://www.excelforum.com/member.php...o&userid=16139 View this thread: http://www.excelforum.com/showthread...hreadid=276569 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
How do I use conditional formatting for multiple rows? | Excel Worksheet Functions |