conditional formatting with text
enter the equations in a blank cell referencing a cell which you think meets
the character requirements. if the response is false there may be a leading
space and you may have to add a trim() portion
"Christine Hemphill" wrote:
I entered it just like you have below, but everything is now showing as black
text. I went back in and noticed that it replaced all of the (A1,2) with
(A7,2). I may not understand the logic. Why is it replacing that?
"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....?
|