View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default 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,