Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |