More Conditional Formatting

[Sandy]

I am aware that there are three possible conditional formatting entries,
however, I saw somewhere that a 4th can be introduced, (Pseudo? I think but
I can't remember where!) - so is it possible (without VBA) to do the
following.

Assuming Cell C12 formatted as "Number":-

C11 then C12 - Black background

=C11 then C12 - Blue
<C11 then C12 - Red
C12="" then C12 - Yellow

Thanks
Sandy

 

[T. Valko]

Yes, you can get 4 conditions if you are able to make 1 of those conditions
the default. So, based on your explanation you can make this the default
condition:

C12="" then C12 - Yellow

Select cell C12
Set the fill color to YELLOW
Now, set the conditional formatting.
With C12 still selected goto Format>Conditional Formatting
Condition 1
Formula Is: =AND(COUNT(C11:C12)=2,C12<C11)
Set the fill color to RED
Condition 2
Formula Is: =AND(COUNT(C11:C12)=2,C12=C11)
Set the fill color to BLUE
Condition 3
Formula Is: =AND(COUNT(C11:C12)=2,C12>C11)
Set the fill color to BLACK
OK out

 

[T. Valko]

I just thought of something...

I don't know how you intend to use this but I wrote all the formulas to
check that *both* cells contain numbers. If cell C11 can be empty while C12
contains a number then C12 will still have the yellow fill even though it is
not empty.

 

[Sandy]

Excellent - just what I was after
Thank you
Sandy

 

[T. Valko]

You're welcome. Thanks for the feedback!