I have an excel spreadsheet organizing material orders, I have 2 columns “Date Expected” and “Date Delivered” I have 1 row functioning the way that I want it to which is if “Date Expected” is past due and “Date Expected” is blank, then the 2 columns in that row will be red.
The problem is, I want the entire sheet to function this way without having to manually enter the rules for each row. I think it has something to do with the “$” but I can’t get it to work.
This is what I have…
Formula 1: “=IF(ISBLANK($G$2),ISBLANK($H$2))” Applies to: “=$G$2:$H$2”
Formula 2: “=IF(ISBLANK($H$2),$G$2<TODAY())” Applies to: “=$G$2:$H$2”
This DOES work the way I want it to, but I would have to format each row separately.
I am very new to excel, please help!