# 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,
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.

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