View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Conditional Formatting Not Blank Cells

If you have formulas in those other cells, then they are not blank. If that
is the case, then use this formula instead.
=NOT($F2="")

HTH,
Paul

--

"Nate" wrote in message
...
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