Color Auto Fill

[SWILL]

Hey all, how do I fill a cell with color when the numbers are between a certain range? Ex: if the cell contains the numbers between 16 and 25, turn the cell red, if the numbers are between 10 and 15.9, turn the cell yellow, and so on.

Thanks,

stan

 

[VoG]

Try Conditional Formatting http://www.contextures.com/xlCondFormat01.html

 

[pagrender]

You can use Conditional Formatting to accomplish your task. Have you given it a try yet?

 

[SWILL]

That worked great, thank you.