how do i give differect color for validation list?

[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"

 

[carlo]

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

 

[T. Valko]

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