Conditional formatting between 2 different columns

Closed
Rob P. - Sep 6, 2016 at 06:54 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 7, 2016 at 11:29 AM
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.


Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 7, 2016 at 11:29 AM
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
0