PDA

View Full Version : Conditional formatting



YasserKhalil
04-28-2012, 11:54 AM
Hi everyone
I want to combine two conditions to apply conditional formatting
I want to colour cell R12 if r12 is empty and c12 isn't empty.
If c12 is empty then r12 shouldn't be coloured

p45cal
04-28-2012, 02:27 PM
the following conditional formatting in R12:
=AND(ISBLANK(R12),NOT(ISBLANK(C12)))

mancubus
04-28-2012, 02:31 PM
hi. you may use a formula like this:

=AND(LEN($C$12)>0,LEN($R$12)=0)