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.

Use this formula:

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

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

--
Biff
Microsoft Excel MVP


"LeBeauf8331" <(E-Mail Removed)> wrote in message
news:96B754B8-8B13-472D-A21D-(E-Mail Removed)...
> 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.