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

"Adeel" wrote:

HI

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




"Adeel" wrote:

Hi,

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


"Mike H" wrote:

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

"Adeel" wrote:

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,