Forum Discussion
Scott_H_7
Jun 16, 2022Copper Contributor
how would I get the cell to go red if the date input is greater than a year from present day?
Hi,
On my spreadsheet I have sections where dates are inserted - how would I get the cell to go red if the date input is greater than a year from present day?
Thanks in advance,
Scott
9 Replies
Sort By
- PreformCopper Contributor
Scott_H_7
How about using Conditional formatting on the Home Tab?
Select the area that you want to apply this behavior to.
On the Home Tab, select Conditional Formatting - > Highlight Cells Rules -> Greater Than...
Add "=Now() + 365" or "=TODAY() + 365" into the left "textbox" and select preferred color formatting in the right Dropdown.=Now() gives you the current time. ie. 2022-06-16 14:00
=TODAY() gives you the starting time of today. ie. 2022-06-16 00:00
365 is number of days and gives the same time 365 days ahead.
with decimals it will look at a different time of the day.- Scott_H_7Copper ContributorHi Preform,
Thanks for the detailed response - I have tried this and it is not working - however I tried the LESS THAN and it worked ?!
- PeterBartholomew1Silver Contributor
- Scott_H_7Copper ContributorHi Peter, i have tried this but sadly it is not working for me