IF - Colour Cell

[Mr B G]

Hi all,

I want to change the colour of a cell if the number is within a certain range.

So, for example;

If this cells number is 0-60 I want it green
If this cells number is 61-90 I want it orange
If this cell number is 91+ I want it red

Is this possible?

Thanks,

 

[VoG]

Take a look at Conditional Formatting http://www.contextures.com/xlCondFormat01.html

 

[Mr B G]

I was just looking at that, but it keeps doing a gradient of colours rather than just one colour depending on where the number falls.

I'll keep playing with it.

 

[Mr B G]

It's ok, I found it!

In conditional formatting, there is an option to use icons and then set the ranges you want them as.

Thanks for the quick response!!

 

[VoG]

You will need 3 conditions like this

Excel Workbook
	A
1	25
2	73
3	123
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Cell Value less than or equal to60	Abc
A1	2. / Cell Value between 61 and 90	Abc
A1	3. / Cell Value greater than or equal to91	Abc