Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I had been formatting a cell colour to pink green or blue depending on if it
contained E, M or L. I've now had to change my cell contents to E1, E2, E3, E4 etc instead of just 'E' so I've gone over my limit of 3 conditional formats. Is there a way I can conditionally format based just on the letter E M or L and not the number with it? Or can you think of another way to achieve the same thing? Much obliged for any help suggested. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
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 based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |