LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Excel 2003 - Adding up cells that contain Conditional Formatting

Hi. I've got a spreadsheet that has conditional formatting in one column as
follows:

1-14 days - green
15-30 days - yellow
over 30 days - red

I need to be able to have each color total up into three different cells,
meaning, 3 green, 10 yellow, 31 red. Is there a formula to do that
automatically?

Thank you for any assistance.
--
FlorencePS
 
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
Adding cells of same conditional formatting Mick Excel Worksheet Functions 0 May 7th 09 04:51 PM
conditional formatting in excel 2003 GrouchyMammy Excel Worksheet Functions 5 April 13th 09 03:05 AM
Conditional formatting excel 2003 [email protected] Excel Worksheet Functions 1 April 14th 08 11:43 AM
How can I keep conditional formatting when adding rows to excel? Excel one tenth guru Excel Discussion (Misc queries) 0 January 10th 07 02:57 PM
Excel 2003: Conditional Formatting oceanmist Excel Discussion (Misc queries) 3 September 20th 06 10:55 PM


All times are GMT +1. The time now is 09:52 PM.

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

About Us

"It's about Microsoft Excel"