Conditional Formatting?

[Ben_Notts2]

Hi Folks,

I have a list of numbers in column A (Ranging between 1 and 300,
I would like the cell colour to change automatically.... dependant of the inputted value

1 - 99 = Green
100 - 199 = Orange
200 - 300 = Red

Any help would be greatly appreciated

kind Regards

Stephen

 

[SanjayGMusafir]

1 - 99 = Green
100 - 199 = Orange
200 - 300 = Red

Use Three Formulae for Conditional formatting -

=And(A1>=1,A1<=99)

=And(A1>=100,A1<=199)

=And(A1>=200,A1<=300)

 

[Ben_Notts2]

Thank You

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.