How do I sum.....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up the column to be r=color RED, g =color GREEN, y = color YELLOW.
Basically Red = no started, Y = working, and Green = completed. I want to
sum all the field to determine percentage complete. So if all Green then
100% complete. If I have 10 fields and 5 are Green and 5 are either yellow
or red then total is 50%. How do I create that formula?
 
Peo -

Thanks, that is exaclty what I needed. Can you help me take it a step
further:

If I am less than 50% show red, between 50-99% show yellow and 100% show
green for the summed field.

Thanks!

Mark
 
Take a look at Format|Conditional formatting.

You'll see that you can specify up to 3 formats (which sounds perfect for you!).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to sum "unique" samples 2
Conditional Formatting 3
Excel 2003 - Adding up cells that contain Conditional Formatting 10
How do I invoke a call in Excel 4
How do I get cell to change background color automaticly (4color) 1
How to filter rows data based on background color of individual cells 1
Excel 2002: How to conditional format band of colors ? 2
Creating drop down lists with multiple options? 4

Back
Top