Home |
Search |
Today's Posts |
#1
|
|||
|
|||
... I would like to apply more than 3 conditional formats ...
I would like my Cells to be shaded based on the Values that are entered into
them. I thought that Conditional Formating would be the answer, but it appears I'm only able to enter three conditions. I have a posibility of five values that could be entered into the cells: "-", "1", "2", "3" or "4". The conditions I reqiure are" if the cell contains "-", then shade "light yellow" if the cell contains "1", then no shade if the cell contains "2", then shade "grey" if the cell contains "3", then shade "yellow" if the cell contains "4", then shade "red" Is there a means to enter more than the three conditions that are allowed by the dialog box? Respectfully, Darrell |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I Apply Conditional Formatting to a Chart? | Charts and Charting in Excel | |||
How do I apply conditional formatting to a text box | Excel Worksheet Functions | |||
Automatic updating of Conditional Formats using dates | Excel Worksheet Functions | |||
how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
Conditional Formats in Excel | Excel Worksheet Functions |