colour formatting

  • Thread starter Thread starter Colsey
  • Start date Start date
C

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
 
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
 
Thanks for that - thats done just the job :)


Robert Rosenberg said:
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
Click to expand...
 
Back
Top