how would I get the cell to go red if the date input is greater than a year from present day?

Question

Hi,&nbsp;&nbsp;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?&nbsp;&nbsp;Thanks in advance,Scott

peterbartholomew1 · Answer

Scott_H_7&nbsp;You could use a conditional format based upon the formula= B3&gt;EDATE(TODAY(),12)

preform · Answer

Scott_H_7&nbsp;How about using Conditional formatting on the Home Tab?Select the area that you want to apply this behavior to.On the Home Tab,&nbsp;select Conditional Formatting - &gt; Highlight Cells Rules -&gt; Greater Than...Add "=Now() + 365" or "=TODAY() + 365" into the left "textbox"&nbsp; and select preferred color formatting in the right Dropdown.&nbsp;&nbsp;=Now() gives you the current time.&nbsp; ie.&nbsp;2022-06-16&nbsp;14:00=TODAY()&nbsp;gives you the starting time of today.&nbsp; ie.&nbsp;2022-06-16 00:00365 is number of days and&nbsp; gives the same time 365 days ahead.with decimals it will look at a different time of the day.&nbsp;

scott_h_7 · Answer

Hi Peter, i have tried this but sadly it is not working for me

scott_h_7 · Answer

Hi Preform,Thanks for the detailed response - I have tried this and it is not working - however I tried the LESS THAN and it worked ?!

preform · Answer

Scott_H_7&nbsp;Hm.. "date input is greater than a year from present day" was this meant as in the past?In that case, I would have thought LESS THAN would need&nbsp; "=TODAY() - 365" in the dialog.I'm just happy you solved it!Best regard

Forum Discussion

how would I get the cell to go red if the date input is greater than a year from present day?

9 Replies

Resources