how to highlight a cell in C:C in red if the date is less than today's date and the corresponding value in M:M <> "Done"

[amay]

I'm tracking dates on a "project".
I want the date to:
1. go red if it is greater or equal to today's date (in C:C) and the activity is NOT marked as "Done" in M:M
2 go yellow if today's date is within 7 days from the date for the corresponding row in C:C and the activity is NOT marked as "Done" in M:M

I tried the Conditional Formatting option, but only had limited success.

 

[etaf]

=AND($C1<=today(), $C1<>"", $M1<>"done")

when you say

greater or equal to today's date

Do you mean the date is in the future
=AND($C1>=today(), $M1<>"done")

Or past
=AND($C1<=today(), $C1<>"", $M1<>"done")

Yellow

again 7 days , so thats based on today() date 16-sep
that greater then today() but less than today() +7

=AND( $C1>today() , $C1<today()+7 , $M1<>"done")

post a sample

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A1:M1000000 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND($C1>=today(), $M1<>"done")

Format [Number, Font, Border, Fill] format red
choose the format you would like to apply when the condition is true
OK >> OK

repeat for the yellow rule
PUT the Yellow rule - first in list - using the arrows and STOP IF TRUE