Hi, I'm sure this will be an easy one for you all, but I can't find an answer online and I can't figure out how to make it work. I've tried various conditional formatting rules, which I'd prefer if possible, but none of them works when conditions are met. So I resorted to macros and have spent 2...