| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting, change row to certain color | Excel Worksheet Functions | |||
| Change background color using conditional formatting | Excel Worksheet Functions | |||
| How can I change cell color using conditional formatting | Excel Discussion (Misc queries) | |||
| change color of text in cell without conditional formatting | Excel Discussion (Misc queries) | |||
| Cell color change without using conditional formatting | Excel Discussion (Misc queries) | |||
Linear Mode
