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
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history ✓ - Facebook Forum
- Clear formatting in excel - Guide
- Based on the values in cells b77 b81 c77 - Excel Forum
- Phone formatting software for pc - Download - File management
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
1 response
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
149
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