Conditional Formatting with date range issue

Hi,

I have a column of dates in column M, and in A1 I have the formula =TODAY() for today's date. I would like to conditionally format all of column M (up to row 198) so that it turns orange if the date in M is before today and after or equal to 3 working days before the date in M.

I have this
=AND($A$1<M2,$A$1>=(WORKDAY(M2,-3))) but it doesn't appear to be working because it's highlighting dates after todays date. Please can you help?

Thanks for your reply, however...

=AND(M1<$A$1,M1<=A1+3) The bold part of this formula - this is saying todays date plus 3 days? this isn't what I'm after. It needs to be 3 working days before the date in column M.

Thanks

Can anyone else help me with this?

Try this

Please Login or Register  to view this content.

Thank you for your help. Within the workday bracket, should it be 3 or -3 if I want it to be 3 days before?

it is not clear.Explain with example.If today is 27/2/20145 what should be M1 values.