I made a task tracker for work, and the conditional formatting for crossing off data and highlighting due dates red when they are overdue is working for volume B & E, but not in columns G-I.

Basically I want if column C says “Done” then I want the data in that row to be crossed out in columns B, E, G-I and want column G in rows 20 & down to not be red anymore.

I’ve tried changing the order of the conditional formatting rules, but it doesn’t seem to work for me. I do have a macro installed, so I’m wondering if I missed something in the coding?

sample

I built the sheet myself following the steps in this video playlist, but have added some things to customize it for me.

I’m hoping it’s something super simple that I’ve overlooked, but any help would be appreciated.