• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel formulating

edmundoab

edmundoab

Diamond Member
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?
 
try searching on the web for "conditional formatting". I dont have office on this machine, so I cant help you more than that.
 
For Office 97 -> Format -> Conditional formatting. Brings up a nice menu with conditions to set and colors to choose.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top