| 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....? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting with text
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....? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting with text
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....? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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....? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting with text
make sure you enter the cell name of the first cell in the selectied cells in
the conditional format equation "Christine Hemphill" wrote: 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....? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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....? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting with text
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 on that one cell. I changed the conditional formats to look at that cell. It is still not working. Help. "bj" wrote: make sure you enter the cell name of the first cell in the selectied cells in the conditional format equation "Christine Hemphill" wrote: 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....? |
| Reply |
| 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) | |||
Linear Mode
