Conditional Formatting Help Please

[Hale]

Hi guys, my Excel skills are lacking so hoping someone can take a look at this for me.

I would like to format the Status column in Excel so that it will highlight green whilst the date and cycle hasn't been breeched but will highlight red for example when the date hits Nov-16.

Date Cycle (Months) Status
Oct-15 12

Any help will be greatly appreciated

[JohnTopley]

TRY in Conditional Formatting

"Use formula ....."

=TODAY()<=EDATE($A2,$B2) Green


=TODAY()>=EDATE($A2,$B2) Red

[Hale]

Thanks for coming back to me John.

You've put me on the right path and I'm pleased to say its working

Thanks again

[JohnTopley]

Thank you for the feedback.

If you have a solution, can you please mark thread as SOLVED ("Thread Tools" at top of first post)