View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default how do i give differect color for validation list?

Try this.

Select the cell in question. Assume that is cell A1.
Goto the menu FormatConditional 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


--
Biff
Microsoft Excel MVP


"imratish" wrote in message
...
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"