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

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.
 
T

T. Valko

Use this formula:

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Changing the color of rows - conditional formatting 3
Conditional Formatting to Another Cell 0
Using checkbox to change cell color 2
Conditional Formatting For Highlighting a Cell Color 2
Conditional formatting based on formula cell 4
Using colour conditional formatting to show whether due date has past 0
Conditional formatting 2

Top