Conditional Formatting based on a Formula

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.

Hi Dred,

It looks like your last reply is definitely on the right track. It colors some of the row when the back order Column has no text in it (back order, discontinued, not available. Currently, column's A C G H are the only ones that are coloring.

With regards the back order formatting, I want the entire row to be in the color when it shows as back ordered, not available, or discontinued.
I have tried both of the Back Order rules. Rule #1 doesn't do anything when there is text in 'C' and rule 2 only colors the Original Date (Column A).

Both Rules are applying to the $A$3:$M$3. I will be copying the rules down each row.

I've reattached a new file.

Special Order File - Generic.xlsx

Thanks

Awesome SOLVED!