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