Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula... conditionnal format
Hi,
Cell A1 has a dropdown list (from Data/Validation/list) with dates except one option wich is Released. What I want is that: A1 stays red when nothing is in the cell A1 becomes yellow when I choose a date from my list A1 becomes green when I choose Released from my list. Please help. Red works, yellow works even when I choose Released...but I want it to be green when it's released. Thanks. Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula... conditionnal format
format the cells to be yellow
then do format=conditional formatting for condition 1, cell value is equal to ="Released" format Pattern Tab choose green for condition 2 Cell Value is equal to ="" Regards, Tom Ogilvy "Paul" wrote in message ... Hi, Cell A1 has a dropdown list (from Data/Validation/list) with dates except one option wich is Released. What I want is that: A1 stays red when nothing is in the cell A1 becomes yellow when I choose a date from my list A1 becomes green when I choose Released from my list. Please help. Red works, yellow works even when I choose Released...but I want it to be green when it's released. Thanks. Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to format | Excel Discussion (Misc queries) | |||
Conditionnal Formatting | Excel Worksheet Functions | |||
How to create icon sets for excel 2007 conditionnal formating ? | Excel Discussion (Misc queries) | |||
How to program a macro to hide rows with conditionnal formating | Excel Discussion (Misc queries) | |||
Format\Formula Help | Excel Worksheet Functions |