How to change the colour of a cell based on the value of another cell

[RobD1975]

Hi Everyone,

I'm sure this is a basic question, so please excuse my ignorance. I am trying to format the fill colour of a cell based on the value in a different Cell.

So for instance if Cell A1 will have a range of values between 1 and 15, I want cell B1 to turn green if the value in cell A1 is between 5 and ten, turn orange if between 1 and 5 and turn red if 0.

Is there a way to do this, I have tried conditional formatting, but I cant seem to get the desired result.

Many thanks in advance

Rob

 

[Marcelo Branco]

Welcome to Mr Excel

The rules are not well defined
0 -> red
1 - 5 -> orange
5 - 10 -> green

Questions:
5 should it be orange or green?
What about 11-15?

M.

 

[Scott T]

In Conditional formatting you will need 3 rules, one for each color. Changing the number to match your criteria.

=AND(A1>=5,A1<=10)

 

[RobD1975]

Sorry,

0 = red
1 - 5 = orange
6 - 15 = Green

 

[Marcelo Branco]

Sorry,

0 = red
1 - 5 = orange
6 - 15 = Green

You need 3 rules

=A1=0
Red

=AND(A1>=1,A1<=5)
Orange

=AND(A1>=6,A1<=15)
Green

M.

 

[RobD1975]

Thank you both, I have sorted it now thank you for your help

Kind regards

Rob