color cells automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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
 
I tried the formula noted below and I get an error pop up.

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

What now?
 
I fixed the error issue but the condition does not change the font color if
the cell is blank.
 
Back
Top