| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Not Blank Cells
Hello,
I'm Using XL 2003. I would like to apply a conditional format to the range of cells A2:F171. Basically, I would like to highlight all of the rows that have a value in column F, and the rows that have no value or are blank in column F should remain unchanged. I tried using the formula =NOT(ISBLANK($F2)). But it highlights all cells in the array. Any suggestions would be greatly appreciated. Thanks, Nate |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP - Conditional Formatting Dates & Blank Cells | Excel Worksheet Functions | |||
| Conditional Formatting - allowing for Blank Cells | Excel Discussion (Misc queries) | |||
| Is conditional formatting only blank, unused cells possible? | Excel Worksheet Functions | |||
| using conditional formatting - blank cells | Excel Discussion (Misc queries) | |||
| Conditional formatting blank cells | Excel Discussion (Misc queries) | |||
Threaded Mode
