I would like to have cell A2 with a red font if the rest of the row is blank.
If anything is entered in any other cell I want it to return to the
black(auto) font setting. I have tried several formulas and can onlt get it
to work if cell A3 gets data entered.

Thanks

A3 isn't in the same row as A2, so how did you manage that?

Railrd wrote:

I would like to have cell A2 with a red font if the rest of the row is blank.
If anything is entered in any other cell I want it to return to the
black(auto) font setting. I have tried several formulas and can onlt get it
to work if cell A3 gets data entered.

Thanks

I assume you are using conditional formatting
try equation is counta(B2:IV2)1

"Railrd" wrote:

I would like to have cell A2 with a red font if the rest of the row is blank.
If anything is entered in any other cell I want it to return to the
black(auto) font setting. I have tried several formulas and can onlt get it
to work if cell A3 gets data entered.

Thanks

If you really want A2 to be red font if the rest of row 2 is blank then
use "Formula is" =COUNTA($B$2:$IV$2)=0 and set red font. That's all you
need. The "Auto Black" is the default, and you don't need to mess with it.

Railrd wrote:

I would like to have cell A2 with a red font if the rest of the row is blank.
If anything is entered in any other cell I want it to return to the
black(auto) font setting. I have tried several formulas and can onlt get it
to work if cell A3 gets data entered.

Thanks

Thanks to the both of you didn't think about using COUNTA. That was a typo I
had meant cell B2.

Thanks again


"Bob I" wrote:

If you really want A2 to be red font if the rest of row 2 is blank then
use "Formula is" =COUNTA($B$2:$IV$2)=0 and set red font. That's all you
need. The "Auto Black" is the default, and you don't need to mess with it.

Railrd wrote:

I would like to have cell A2 with a red font if the rest of the row is blank.
If anything is entered in any other cell I want it to return to the
black(auto) font setting. I have tried several formulas and can onlt get it
to work if cell A3 gets data entered.

Thanks

You're welcome, have a good day.

Railrd wrote:

Thanks to the both of you didn't think about using COUNTA. That was a typo I
had meant cell B2.

Thanks again


"Bob I" wrote:


If you really want A2 to be red font if the rest of row 2 is blank then
use "Formula is" =COUNTA($B$2:$IV$2)=0 and set red font. That's all you
need. The "Auto Black" is the default, and you don't need to mess with it.

Railrd wrote:


I would like to have cell A2 with a red font if the rest of the row is blank.
If anything is entered in any other cell I want it to return to the
black(auto) font setting. I have tried several formulas and can onlt get it
to work if cell A3 gets data entered.

Thanks