Hi all,

I'm a bit of a noob to excel programming, but have used it extensively for data analysis during my doctorate...

I am not working on a CRM system for a company and have 3 sheets - 1)clients info & notes, 2)sales log, 3)Orders

I have used conditional formatting to highlight different orders (rows) in different colours depending on how close to the due date we are. I need to have this overrided so that when I input a completion date in the cell next to the due date, the entire row becomes grayed out.

I cant seem to get this last part right..

any help would be great

thank you