View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
carlo carlo is offline
external usenet poster
 
Posts: 367
Default how do i give differect color for validation list?

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

On Nov 19, 4:28 pm, imratish
wrote:
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"