Conditional formatting - with 2 conditions

[Forum freak \(at work\)]

Hi

If cells C1 and B1 are empty C1 fill colour is "no fill"
I want cell C1 fill colour to change from "no fill" to yellow when B1 is not
empty and C1 remains empty.
However I want C1 fill colour to revert to "no fill" if data is entered into
C1 regardless of the condition of B1

Can this be done?

Kenny W
XP pro
Office 2003

 

[Peo Sjoblom]

As condition 1 use

formula is

=AND($B$1<>"",$C$1="")

select format button and yellow pattern and click OK twice

--


Regards,


Peo Sjoblom

 

[ShaneDevenshire]

Hi,

I think this is what you want:
1 Select cell C1 and choose Format, Conditional Formatting,
2. From the first drop down choose Formula is
3. Enter the following formula in the next spot
=AND(B1<>"",C1="")
4. Click the Format button and pick Yellow on the Patterns tab, click OK
twice.

If this helps, click the Yes button.