Hello I am not that good at excel and I am trying to highlight cells that have dates greater than a certain number of weeks to be either yellow, green or red

Im trying to add two dates together in two different columns and if the outcome is greater than 21 days =hightlight yellow
Greater than 28 days = Hightlight Green


Greater than 14 days = hightlight Red

Try using formulas like this

=AND(A1-B1>=14;A1-B1<21)
=AND(A1-B1>=21;A1-B1<28)
=A1-B1>=28

That should do the trick.

/Møller