Conditional Formatting (ignore unpopulated cell)

[kms508]

I am doing a conditional format in which the color of a cell will be green if the value is larger than another cell (a goal cell) or red if it is less than that goal cell. When the goal cell is unpopulated, the conditionally formatted cell will always return green. I want it to ignore an unpopulated goal cell rather than read the goal cell as zero. How do I do this?

 

[Scott Huish]

Since you didn't provide any specifics, in this example I am using C1 as the cell with Conditional Formatting and A1 as the cell you are comparing to:

Formula Is:
=AND($C1>$A1,$A1<>"")

 

[Andrew Poulsom]

Use a Conditional Formatting Formula like:

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

 

[Jonmo1]

Whatever formula you have for the conditional format formula, add AND to it..

Say your current formula is
A1 = Cell to Color
B1 = GOAL Cell

=A1>B1    -   formats Green
=A1<B1    -   formats Red

Change to

=AND(A1>B1,B1<>"")
=AND(A1<B1,B1<>"")