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

I've used conditional formatting many times and this is the first time it hasn't worked as I expected.

I have three conditional colors that I want to apply across a row, from columns B to F, and I want to apply this coloring one row at a time to rows 15 to 145. I have a formula to determine which rows should, and should not, be colored.

The good news is that color appears on every row that should have color, and does not appear on every row that should not have color.

The bad news is that the color appears in only one column of each row that should be colored and not all of the columns from B to F. Two of the conditional coloring commands color only cells in column 'B' and one conditional coloring command colors only cells in column 'F'. However, to repeat, the proper color always appears in the proper row.

I used =$B$15:$F$145 to designate the area to which the formulas for conditional coloring should be applied.

Does anyone have an idea of what I've done wrong?

This has always worked fine before, so I'm very puzzled.

What formula did you use?


Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.