Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have set up in conditonal formating to change cell patterns to be a certain
color based on the date. The below conditional formating formula works, now what I need to for the words (Red, Yellow, or Green to automatically appear in the cell based on the color i.e if cell color is Red I what the word Red to appear in the cell. How can I do this? =F2<=TODAY() (pattern color Red) =F2<=TODAY()+5 (pattern color Yellow) =F2<=TODAY()+25 (pattern color Green) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
Expanding conditional formating with reference cells changing | Excel Discussion (Misc queries) | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) | |||
Conditional Formating when result is text | Excel Worksheet Functions | |||
30 Day Aging Report Using Conditional Formating | Excel Worksheet Functions |