How to change the color of a cell using conditional formatting?
 

The question does not really detail my issue, so here it is.
How do I change the color of a cell based on three conditions. How should I
structure the conditional format rule if the cell is "not blank" and is "not
equal to" two specific numbers. For example, F4 is not blank, F4 does not
equal 12345, and F4 does not equal 98765. I know its probably something
extremely easy to do, but the checking for "not blank" is stumping me.

How to change the color of a cell using conditional formatting?
 

Use this formula:

=AND(F4<"",F4<12345,F4<98765)

<"" means: not equal to blank (is not blank)

--
Biff
Microsoft Excel MVP


"LeBeauf8331" wrote in message
...
The question does not really detail my issue, so here it is.
How do I change the color of a cell based on three conditions. How should
I
structure the conditional format rule if the cell is "not blank" and is
"not
equal to" two specific numbers. For example, F4 is not blank, F4 does
not
equal 12345, and F4 does not equal 98765. I know its probably something
extremely easy to do, but the checking for "not blank" is stumping me.