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

  • Thread starter Thread starter LeBeauf8331
  • Start date Start date
L

LeBeauf8331

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)
 
Back
Top