Excel formulating

[edmundoab]

Hi guys,

A colleague of mine wants to set columns on Excel to have the software convert a certain value to a preset color.

Say like range from 1 to 10, change the column color to Green

Say like 11 to 50, change to Blue Color

and 51 to 100, change to red


I could not help him off my head as I have no clue how to do it.
Any ideas?

 

[Whitecloak]

try searching on the web for "conditional formatting". I dont have office on this machine, so I cant help you more than that.

 

[akenbennu]

For Office 97 -> Format -> Conditional formatting. Brings up a nice menu with conditions to set and colors to choose.

 

[edmundoab]

Using Office 2003, yeah it works the same on that function at conditional formatting.
Thanks man!