Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
hi
I am trying to format a cell to change two two different colors when values in two other cells meet some conditions. For example The cell being formatted is E2 (This cell will have no text just a color pattern) I want it to change to Yellow when a particular date is reached in B2 (This I have figured out) I want the cell to change to green when the first condition is met AND there is any alphanumeric data in F2 Any ideas or suggestions. Any help would be appreciated Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |