Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Hi,
I have a cell (b1) that I am trying to conditionally format. This cell (b1) is referencing another cell (a1). Cell A1 has 6 potential selections in a drop down menu. These selections in cell a1 a Blue Blue Grey Green Black Red Purple I want to conditionally format cell b1 so that if any selection other than red or purple is selected in cell a1, then cell b1 gray's out. I know how to do the formatting to gray the cell out, but unfortunately you can only have 3 conditional statements in Excel. Is it possible to make 4 conditional statements? For instance, can I combine the conditional statement for "Blue" and "Blue Grey" somehow since they begin with the first four same letters? Thank you for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |