I'm looking to add cells (that are formated in %) in them.
 

a1 has 10%
a2 has 30%
a3 has 10%
a4 has 20%
a5 has 5%
a6 has 15%
a7 has 10%

a8 needs to be ONLY "100%" total the above percentages or default to red in
color if below 100%

I'm looking to add cells (that are formated in %) in them.
 

=Sum(A1:A7)

Do you want to turn the fill color red or the font color red? If the
former, try conditional formatting (Format/Conditional Formatting). If the
latter, try a custom number format (Format/Cells/Custom)

[Red][<1](0%);0%


"j5b9721" wrote:

a1 has 10%
a2 has 30%
a3 has 10%
a4 has 20%
a5 has 5%
a6 has 15%
a7 has 10%

a8 needs to be ONLY "100%" total the above percentages or default to red in
color if below 100%

I'm looking to add cells (that are formated in %) in them.
 

when you say "ONLY" 100%, is it possible the sum of A1:A7 could be greater
than 1? If so, maybe you want:

=MIN(SUM(A1:A7),1)

Your example totals 100%, so I'm not sure I'm following you.



"j5b9721" wrote:

a1 has 10%
a2 has 30%
a3 has 10%
a4 has 20%
a5 has 5%
a6 has 15%
a7 has 10%

a8 needs to be ONLY "100%" total the above percentages or default to red in
color if below 100%

I'm looking to add cells (that are formated in %) in them.
 

Thank You JMB!!!! Your a life saver!!!

"JMB" wrote:

=Sum(A1:A7)

Do you want to turn the fill color red or the font color red? If the
former, try conditional formatting (Format/Conditional Formatting). If the
latter, try a custom number format (Format/Cells/Custom)

[Red][<1](0%);0%


"j5b9721" wrote:

a1 has 10%
a2 has 30%
a3 has 10%
a4 has 20%
a5 has 5%
a6 has 15%
a7 has 10%

a8 needs to be ONLY "100%" total the above percentages or default to red in
color if below 100%

I'm looking to add cells (that are formated in %) in them.
 

up to 100% works fine and changes to red below 100%, but if the total is over
it stays at 100% and black.
I need it to stay red over or under 100%, but to default to black on 100%
only,
and the percentage to be correct either under or over 100%...

Is this possable???
Joe


"JMB" wrote:

=Sum(A1:A7)

Do you want to turn the fill color red or the font color red? If the
former, try conditional formatting (Format/Conditional Formatting). If the
latter, try a custom number format (Format/Cells/Custom)

[Red][<1](0%);0%


"j5b9721" wrote:

a1 has 10%
a2 has 30%
a3 has 10%
a4 has 20%
a5 has 5%
a6 has 15%
a7 has 10%

a8 needs to be ONLY "100%" total the above percentages or default to red in
color if below 100%

I'm looking to add cells (that are formated in %) in them.
 

Try using:
=Sum(A1:A7)

and this custom number format
[Black][=1]0%;[Red]0%



"j5b9721" wrote:

up to 100% works fine and changes to red below 100%, but if the total is over
it stays at 100% and black.
I need it to stay red over or under 100%, but to default to black on 100%
only,
and the percentage to be correct either under or over 100%...

Is this possable???
Joe


"JMB" wrote:

=Sum(A1:A7)

Do you want to turn the fill color red or the font color red? If the
former, try conditional formatting (Format/Conditional Formatting). If the
latter, try a custom number format (Format/Cells/Custom)

[Red][<1](0%);0%


"j5b9721" wrote:

a1 has 10%
a2 has 30%
a3 has 10%
a4 has 20%
a5 has 5%
a6 has 15%
a7 has 10%

a8 needs to be ONLY "100%" total the above percentages or default to red in
color if below 100%