Conditional Formatting Across Multiple Columns, But Only Some Columns Turn Color

I added a desensitized file, per TMS's request.

This file acts, in most ways, the same as my original file, with one exception - a new problem. One of the conditional formatting colors is applied to an entire column, irrespective of whether color should have been applied to a specific row. Previously, every row had, or did not have, the proper color, with the problem being that the color was not applied across the row to columns 'B' to 'F'.

However, the symptoms are similar enough that I suspect any solution to this problem will work on my original file.

The issue appears to be in the conditional formatting formulas. You are not keeping the referenced columns absolute with $, so the comparisons are not working as you'd expect. For your "green" format, this is your formula:

=COUNTIFS('Input - Membership CSV File'!B$5:B$301,"="&C15,'Input - Membership CSV File'!I$5:I$301,"="&'Instructions and Scratch Pad'!B$123,'Input - Membership CSV File'!N$5:N$301,">="&TEXT('Instructions and Scratch Pad'!B$122-45,0))

I changed it to this, and it works:

=COUNTIFS('Input - Membership CSV File'!$B$5:$B$301,$C15,'Input - Membership CSV File'!$I$5:$I$301,'Instructions and Scratch Pad'!$B$123,'Input - Membership CSV File'!$N$5:$N$301,">=" & ('Instructions and Scratch Pad'!$B$122-45))

A similar change can be made to the "pink" formula. I recommend moving the green formula to the top of the conditional format rule list, and checking Stop if true checkbox for it. Your purple formula references column XFB throughout, so I'm really not sure what you're expecting there.

Thank you! It took me a stupid long-time to find all of the missing $ in the formula, but once I understood what was missing, it worked perfectly. This is a lesson I will NOT forget.

Melvosh has identified the problem. The conditional formatting works perfectly now.