Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting with text
I am trying to make three conitional formats on a cell with text.
The cell text will be one of the following: Di...... Do..... or something else. If the text begins with Di, I wat the cell format to be red text. If the text begins with Do, I want the cell format to be blue text. If the text does not begin with Di or Do, I want the cell format to be black text. I set the conditional formatting as follows: Cond #1: Cell Value is not between Di & Do then black Cond #2: Cell Value is greater than Di then red text Cond #3: Cell Value is greater than or equal to Do thenblue text Condition #1 is overwriting condition #3. If I switch them, cond3 overwrites cond1. How do I make this work? Is there a way to say If Cell Value is greater than Do....? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
How do I apply conditional formatting to a text box | Excel Worksheet Functions | |||
Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) |