Hi Everyone.

I am new here and have been trying to get some conditional formatting working on an entire row based on a formula. I have attached a copy of the file.

The goal is to have the entire row highlight in color 1 if the Original Date >= 7 days compared to the Current Date AND the item is not part of the Back ordered/ discontinued. not available from a list called backorder on sheet 2. If the item is indicated as back ordered then I want to have it colored in color 2. I understand that these two conditionals would need to be on two seperate conditions.

The formula I have been trying is =IF(AND(N3>=7,C3<>Backorder), 1, 0). While some of the coloring is showing it only is highlighting 2 or 3 cells of the row and wont self update.


Special Order File - Generic.xlsx

Thanks a Ton.