Date Forumla/Conditional Formatting

[superlukeyboy]

sorry in advance if this post is in the wrong forum but this one seemed best

i am trying to set up a formula or conditional formatting rule such that if the date entered in the box is more that 6 months ago the box turns red. if its not more than 6 months ago nothing happens. i havn't got a clue how to do this so have turned to msj for help.

if its possible to make it so that if the date is more than 4 months ago it turns orange and then turns red after the 6 month boundary has passed that would be great but i dont know if it can be done

if anyone can help that would be really amazing and you would be saving my ***

thanks all

[daddylonglegs]

Try this

Assuming your date is in cell A1. Select that cell

Format > Conditional Formatting

Select formula is option for condition 1 and use formula
=(A1<>"")*(DATEDIF(A1,TODAY(),"m")>5)
select red format then add a second condition and use formula
=(A1<>"")*(DATEDIF(A1,TODAY(),"m")>3)
select orange format

[superlukeyboy]

thanks a lot, it worked a treat