how do i give differect color for validation list?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a validation list True, False.
I would like to have blue color appearing in back ground whenever i select
"True" and Red color whenever i select "False"
 
Select the cell and then go to Format --> Conditional Formatting
there you select "cell value is" + "equal to" + false
(you have to write false, and select the first two items)
select your format, click on add
and do the same with true.

hth

Carlo
 
Try this.

Select the cell in question. Assume that is cell A1.
Goto the menu Format>Conditional Formatting
Condition 1
Select Formula Is: =A1
Click the Format button
Select the Patterns tab
Select a BLUE fill color
OK
Click the Add button
Condition 2
Select Formula Is: =AND(A1<>"",A1=FALSE)
Click the Format button
Select the Patterns tab
Select a RED fill color
OK out
 
Back
Top