conditional formatting with text
I rechecked. It replaced the 1 with a 7 when I used the format paste function
on a cell in row 8. Now that I know why it did that, I still don't know why
it didn't work on the first one. Please help.
"bj" wrote:
try
=and(left(a1,2)<"Di",Left(A1,2)<"Do") for black
=left(A1,2)="Di" for red
=left(A1,2)="Do" for blue
"Christine Hemphill" wrote:
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....?
|