conditional formatting with text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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....?
 
try
=and(left(a1,2)<>"Di",Left(A1,2)<>"Do") for black
=left(A1,2)="Di" for red
=left(A1,2)="Do" for blue
 
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?
 
make sure you enter the cell name of the first cell in the selectied cells in
the conditional format equation
 
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
 
Let's see............
There is only one cell that the text is in. That cell is populated using a
formula referring to another tab. I am trying to set up the three conditions
 
Back
Top