Conditional formatting between 2 different columns [Closed]

Report
-
Posts
1918
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 4, 2021
-
Hello,
If someone can please help me.
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.

I put together an example if it makes it easier to understand.

Column A has 3 different values 1, 2, or 6. Column B has numbers ranging from 1-500.

If A1 is 2 and B1 is between 1-341, B1 should be Red.
If A1 is 2 and B1 is between 342-359, B1 should be Blue.
If A1 is 2 and B1 is between 360-396, B1 should be Grey.
If A1 is 2 and B1 is 396 or greater, B1 should be Green.
If A1 is 6 and B1 is between 1-379, B1 should be Red.
If A1 is 6 and B1 is between 380-399, B1 should be Blue.
If A1 is 6 and B1 is between 400-439, B1 should be Grey.
If A1 is 6 and B1 is 440 or greater, B1 should be Green.

Any help in solving this would be greatly appreciated.

Thank you in advance for taking your time to help me.


1 reply

Posts
1918
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 4, 2021
143
Rob P., Good afternoon.

In this case you should create a different formula for each case.

Example case 1:
"...If A1 is 2 and B1 is between 1-341, B1 should be Red..."

Try to do:

Select cell B1

CF MENU --> NEW RULE --> USING FORMULA

Type it at field: =E(A1=2;B1>=1;B1<=341)

Choose RED as fill format
OK

Do the same with others cases.

Please, tell us if it works for you.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!