Setting Cell background color using an IF statememnt

  • Thread starter Thread starter Rob
  • Start date Start date
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.
 
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
 
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
 
Back
Top