color cells automatically

[Guest]

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.

 

[Guest]

You can use Conditional Formatting to do this.

Select your entire range of data, with active cell in top-left corner
From the Format Menu, choose "Conditional Formatting"
Change "Cell Value Is" to "Formula Is"
Enter the formula: =COUNTIF($A1:$Z1,"")>0
Click the FORMAT button and select your format (bold, red)
Click OK

I assumed your data was in columns A through Z for this example. Adjust the
above formula to match your actual range.

HTH,
Elkar

 

[Bill Kuunders]

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

 

[Guest]

I tried the formula noted below and I get an error pop up.

The formula you typed contains an error.....

What now?

 

[Guest]

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

 

[Bill Kuunders]

I tried it again ..works for me.
You can send the file if you like.

 

[Bill Kuunders]

I tried it again ..works for me.
You can send the file if you like.