Bob,

You can use the Conditional Formatting tool on the Format menu to
do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Bob" wrote in message
...
Is there a way to change the background color if a cell has
less than 100%.
Another words I have a cell that that tells me when a number of
things add up to 100% some are complete some are not I want the
cells that are less than 100% to change to yellow so they stand
out.

Thank you for your help.