Conditional Formatting based on year
Solved/Closed
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
-
Feb 2, 2016 at 12:47 PM
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Feb 2, 2016 at 01:23 PM
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Feb 2, 2016 at 01:23 PM
Related:
- Conditional Formatting based on year
- Conditional formatting if two cells match ✓ - Excel Forum
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
- How to clear formatting in excel - Guide
1 response
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
150
Feb 2, 2016 at 01:23 PM
Feb 2, 2016 at 01:23 PM
GOT IT = Wheeeeeee ....
instead of using the "NOW()" command I needed "EDATE()
Substituting "EDATE(TODAY(),-12)" where I had "NOW()-30" does the trick.
The final conditional formatting rules are:
Cell value = "." .......... ......... No Format Set ..... Stop If True
Cell Value <EDATE(TODAY(),-12) ...... Green Background
Cell Value >=EDATE(TODAY(),-12) .... Yellow Background
instead of using the "NOW()" command I needed "EDATE()
Substituting "EDATE(TODAY(),-12)" where I had "NOW()-30" does the trick.
The final conditional formatting rules are:
Cell value = "." .......... ......... No Format Set ..... Stop If True
Cell Value <EDATE(TODAY(),-12) ...... Green Background
Cell Value >=EDATE(TODAY(),-12) .... Yellow Background