Greetings to all,

I am working on an excel gantt chart and would like to get the following results using conditional formatting, applies to =$N$10:$AW$24

=$M10="Yes" | This highlights the entire row.

I would like for it to only highlight 1 cell based on the date in $J10

Capture.PNG