Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 17th 05, 03:00 PM
FTP
 
Posts: n/a
Default Adding percentages in a column and automatic formating of contents

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

  #2   Report Post  
Old May 17th 05, 03:02 PM
N Harkawat
 
Posts: n/a
Default

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



  #3   Report Post  
Old May 17th 05, 03:31 PM
FTP
 
Posts: n/a
Default

I have looked at conditional formatting and it may have what I need but am
unable to figure it out. My goal is to have all the cells adding up to 100%
formatted differently and any additional cells over 100% in the same column
to keep the original formatting. I am only wanting to show one total which
will be the overall for the column and listed at the bottom.

"N Harkawat" wrote:

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




  #4   Report Post  
Old May 17th 05, 06:14 PM
Duke Carey
 
Posts: n/a
Default

If your %s start in cell A2 and go downward from there--

1) highlight the entire range and make sure A2 is the active cell
2) FormatConditional Formatting
3) Formula is
4) =sum(A$2:a2)<=1
5) click on Format button
6) set the format attributes you want
7) OK your way back to the worksheet


"FTP" wrote:

I have looked at conditional formatting and it may have what I need but am
unable to figure it out. My goal is to have all the cells adding up to 100%
formatted differently and any additional cells over 100% in the same column
to keep the original formatting. I am only wanting to show one total which
will be the overall for the column and listed at the bottom.

"N Harkawat" wrote:

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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Skipping and protected cells Dave Peterson Excel Discussion (Misc queries) 6 January 27th 05 11:35 PM


All times are GMT +1. The time now is 06:13 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017