colour formatting

[Colsey]

hi all..

Has anyone any idea how to chnge the colour of the text in say a1, a2, a3
simply from the results of what word is placed in cell a4

TIA

 

[Robert Rosenberg]

Use the Format-->Conditional formatting command.

1. Select cells A1:A3
2. Click Format-->Conditional formatting
3. Change the first dropdown (on the left) to "Formula Is"
4. Enter the following formula in the textbox to the right of "Formula Is":

=$A$4="Hello"

Where:
$A$4 = the cell you're testing
"Hello" = the word/phrase that will make the font color change. Make
sure you place the phrase in quotes.

5. Click the Format button and on the Font Tab change the font color as
desired
6. Click OK twice

 

[Colsey]

Thanks for that - thats done just the job

Use the Format-->Conditional formatting command.

1. Select cells A1:A3
2. Click Format-->Conditional formatting
3. Change the first dropdown (on the left) to "Formula Is"
4. Enter the following formula in the textbox to the right of "Formula Is":

=$A$4="Hello"

Where:
$A$4 = the cell you're testing
"Hello" = the word/phrase that will make the font color change. Make
sure you place the phrase in quotes.

5. Click the Format button and on the Font Tab change the font color as
desired
6. Click OK twice

--
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel