Or even:

=$F2<""

Pete

On Feb 22, 4:54*pm, "PCLIVE" wrote:
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- Hide quoted text -

- Show quoted text -