Take a look at conditional formatting under
Format--Conditoinal formatting




"FTP" wrote in message
...
I have a column of percentages that need to be added. At the bottom of the
column I am showing the total which may be between 1 to 1000%. Is it
possible to have a formula so I can color code cells adding up to a
certain
value to be a different color.

The idea is to show the cells that add up to 100% (when added from top to
bottom) in a different color.
--
ftp