get a colored text in one cell to appear the same way in others

A

anton

I would like to have a cell that says "great" and is colored purple to
appear the same way whenever I type the word "great"
 
R

Ray A

One way
Format>conditional format>formula is>=a1="great"><select formating>
Adjust cell location as required
HTH
 
P

Paul Sheppard

Use conditional formatting, select the range of cells wheer you wan
"great" to be coloured purple, then from the format menu selec
conditional formatting, leave condition 1 as "Cell value is" from th
next drop down select equal to, in the third box type great and the
click on the format button and select the format you wan
 
Top