| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how give excel cell red color if value above range? | Excel Discussion (Misc queries) | |||
| in a data validation list how do i color a choice? | Excel Discussion (Misc queries) | |||
| Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
| How to give function by cell color to sum two value in Excel | Excel Worksheet Functions | |||
| formula from multiple worksheets to give a color output to one wo. | Excel Worksheet Functions | |||
Threaded Mode
