Setting Cell background color using an IF statememnt

R

Rob

Can you set the background color of a cell in Excel based
upon the text input? For example, if RED is entered in
the cell the background is set to RED, if GREEN is
entered it is set to GREEN, etc.
 
C

Chip Pearson

Rob,

You can use the Conditional Formatting tool on the Format menu to
do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
T

tapeery

You can do it with Conditional Formatting.

Go to the Format menu and choose Conditional Formatting.

Then, if cell A1 contains the word RED, then enter this in the formul
bar:

="RED"

...and select the formatting options you want from the palettes in th
dialog box
 

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 does not accept text format! 0
Program buttons to create a word document 0
Sum Column Based on Cell Color 5
Excel 2010 Conditional Formatting 2
Match table shading (color) to Visio color/Transparency 1
Conditional Sum Based on Cell Background Color 6
Conditional Formatting - Assistance Please :( 0
Changing the color of a cell in excel based on due date 2

Top