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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,