I have a large database listing people on an international assignment. I have a column (D) that states their End Date. I would like to turn the whole row of an assignee red (through conditional formatting) if their End Date is past the current date (which I have in cell B2). Can somebody help me with a formula for that. I only know how to do it for a sinlge row!
Thanks!
Thanks!