Conditional formatting for due dates and completion percentages.

Hi All,

I would like to format a project tracker that I have set up on excel.

I have a Deadline/Due date column which gives the date the project needs to be completed by (Column J) and I have a percentage column of an estimated % of how far along the project is (Column M)

What I would like my spreadsheet to do is:

Highlight the date in column J red when the date passes AND the percentage in column M is less than 100%
Not highlight the date if the percentage in column M is 100% and the deadline date in column J has passed
Not highlight the date if the percentage in column M less than 100% and the deadline date in column J has not yet passed

Can anyone help me with this? I have tried everything I can think of and searched numerous posts!

TIA

without looking at the file, maybe this?
=AND($M4<>"",$M4<1,$J4<=TODAY())
(assuming M4 is the cell that would be blank - adjust as needed)

Happy to help