color cells automatically
 

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.

color cells automatically
 

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

"Kesbutler" wrote:

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.

color cells automatically
 

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.

color cells automatically
 

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

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

What now?


"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.

color cells automatically
 

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.

color cells automatically
 

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

--
Greetings from New Zealand

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

color cells automatically
 

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

--
Greetings from New Zealand

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