Conditional Formatting [Closed]

Report
-
Hello,

I have 2 columns. One column needs to be formatted w/ a specific color within a range of numbers depending on the number in the other column.

Example is if A1 is 2 and B1 is between 1-341, B1 should be red.
if A1 is 6 and B1 is between 1-379, B1 should be red.
if A1 is 2 and B1 is between 342-359, B1 should be blue.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!