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