View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FlorencePS[_2_] FlorencePS[_2_] is offline
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