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

G

Guest

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"
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Typed text appears in wrong cell 0
Custom Theme colors - aqua/purple 2
How to filter rows data based on background color of individual cells 1
ViewSonic ColorPro VP2776 Pantone Validated Professional Monitor with Color Calibrator Unboxing 3
LOOKUP 2
cell color 3
How do I change the color the cell becomes when doing a FIND 4
send color filled shape behind text 3

Top