cell color from drop down list

D

doss04

I would like to have a cell change color according to the word used in the
drop down list. (ie) drop down list has CLEAR (which would be green), CAUTION
(which would be yellow), and DANGER (which would be red). Anyone have any
ideas?
 
M

Max

Assuming the droplists are in A1 down,
and you want to conditionally format col B

Select col B (B1 active), then apply the CF using Formula Is:
Condition1: =A1="Clear"
Format > Green
Condition2: =A1="Caution"
Format > Yellow
Condition3: =A1="Danger"
Format > Red
Click to OK out

And if you want the CF to apply to col A,
just select col A, then apply exactly as above (no change)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
 
J

Joerg Mochikun

First use Data => Validation to create the dropdown list. Then use Format =>
Conditional Formatting to set the colors for each entry.

Joerg
 

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

Radio Buttons in a drop down list 2
Creating drop down lists with multiple options? 4
use color coded data on a drop down validated list 1
Data Validation List 1
Filtered drop down list 2
Change font color automatically 6
drop down list that changes cell color upon selection 13
Data Validation - Cell Colour 3

Top