Conditional Formatting based on year
Solved/Closed
BrianGreen
Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
-
Feb 2, 2016 at 12:47 PM
BrianGreen Posts 1010 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Feb 2, 2016 at 01:23 PM
BrianGreen Posts 1010 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
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Conditional formatting if another cell contains any text ✓ - Excel Forum
- Conditional format based on another cell containing text - Excel Forum
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Excel conditional formatting if cell contains multiple specific text ✓ - Excel Forum
1 reply
BrianGreen
Posts
1010
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