| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting-Comparing Two Columns
Not sure what's happening, but that formula should work. Make sure you select the column range, eg. A1:A17 and enter the formula =Countif($B$1:$B$17,A1) in the conditional formatting formula box, adjust the range to cover the entire range. Make sure you use the $-signs to make the range absolute. Also go back and look at the formula. Make sure that it is not enclosed in double-quotes. It should have no quotes around it at all. -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=538973 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
| Conditional formula - language needed | Excel Worksheet Functions | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
