Trying to formulate a cell to chnage colors for a range

August 1, 2012 at 12:20:04
Specs: Windows 7
Looking to change a cell color by the entry of a number.
Like 90-100 would be green
75-89 would yellow
0-74 would be red.

If a score ended up 93 is would change to green or if the score was 74 the cell color would be red.

Help


See More: Trying to formulate a cell to chnage colors for a range

Report •

#1
August 1, 2012 at 13:13:03
Read up on Conditional Formatting in the Excel Help files or DAGS for lots of info and a few videos.

Conditional Formatting is applied in different ways depending on what version you are using, so make sure that any Google results that you view match your version.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question