Formula controlling format based on content of a cell

G

Guest

I need a formula for a cell to control its background color based on the text that paticular cell contains. To be more exact, ie: if the cell contains the name Fred, then the background should be light blue or if the cell contains the name Mary, it should be light red.
 
J

JE McGimpsey

Worksheet functions can't affect format. Check out Conditional
Formatting in XL Help.


"Chris P" <C(remove this)A.(dont use this either)peterson@per-(dont
 

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

Trying to change the background of a cell if I type a certain wor 3
Conditional formatting based on adjacent cell? 1
Conditional Format IF AND 3
Format based on cell contents being a formula or not 2
Designating color in one cell based on data entered in another cel 3
Sum Column Based on Cell Color 5
Conditionally format a cell using a list of data defined in a rang 2
Conditional Sum Based on Cell Background Color 6

Top