I fixed the error issue but the condition does not change the font color if
the cell is blank.


"Bill Kuunders" wrote:

say you want this to happen if cell B1 is blank

select the whole row and go to <format<conditional formatting select
formula is and enter
=$B1=""
select the color in the format.... pop up.

Bill K
--
Greetings from New Zealand

"Kesbutler" wrote in message
...
can anyone tell me if I can color the font of certain cells based on a
blank
cell. I want the font for a row to be red if one cell in the row is blank.