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,

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,

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,

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,

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,

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

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

Formula Is:
=OR(A1="",B1="")
--
Gary''s Student - gsnu200805


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

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