• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting - blank cell gets unwanted format

A

alanj

New Member
There is a formula in C1. Therefore, when I use conditional formatting to fill in the cells, it treats the formula as a really huge number, because it contains text. I know you can use the ISNUMBER formula, if you have 1 condition, but what if you have more than one condition?

This is what I want to do:

If C1>A1, I would like red fill. If C1<A1, I would like green fill. If C1 is blank or has a zero, I'd like the cell to be grey. When I use the ISNUMBER formula with those values, either the red fill or the green fill won't work. Remember: There is a formula in C1.

(Warning! We spell gray with an "e" in Canada)
 
You can use the AND function:

=AND(ISNUMBER(C1),C1>A1)

=AND(ISNUMBER(C1),C1<A1)

=OR(C1="",C1=0)


BTW, what happens when C1=A1?
 
You must log in or register to reply here.
Back
Top