conditional formating If A1 or B1 is blank then C1 (Font Colour Ch

[Adeel]

Hello,
I want to apply conditional formating to the following simple scenario,
If A1 or B1 is blank then C1 (Font Colour Change)
Awaiting for the suggetion of experts,
Thanks in advance,
Regards,

 

[Mike H]

Hi,

Select C1 then
Format|Conditional Format
Select 'Formula Is' and enter
=OR(A1="",B1="")
Pick a font colour
Click OK

Use the format painter to paint this into additional cells in column C if
you need that.

Mike

 

[Gary''s Student]

Formula Is:
=OR(A1="",B1="")

 

[Ashish Mathur]

Hi,

In Format > Conditional formatting, enter the following formula in Formula
is =OR($A$1="",$B$1=""). Select the format you want.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Adeel]

Hi,

It does not work. Can you give me other way to do so.

 

[Adeel]

HI

I am using the Office 2007. I will appreicate if you answer me according to
version.

 

[Mike H]

Hi,

I'm afraid > It does not work isn't very helpful
In what way doesn't it work?
what result did you get and what did you expect?

Mike

 

[Mike H]

Hi,

I'm not familiar with 2007 but I doubt that Microsoft will have change
Boolean logic but maybe you enter conditional formats differently.

Mike