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

As condition 1 use

formula is

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

select format button and yellow pattern and click OK twice

--


Regards,


Peo Sjoblom

"Forum freak (at work)" wrote in message
...
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

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.
--
Thanks,
Shane Devenshire


"Forum freak (at work)" wrote:

Hi

Can this be done?

Kenny W
XP pro
Office 2003