LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Summing a range depending on cell background colour

I would like to know how to sum a range depending on cell background colour
so if range was background colour red for example it would sum all the red
shaded cells that have numbers in them. Any help appreciated
 
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
how do i change cell background colour depending on its content? demble Excel Discussion (Misc queries) 2 May 2nd 07 05:50 PM
change a cell background colour to my own RGB colour requirements Stephen Doughty Excel Discussion (Misc queries) 4 June 16th 06 01:08 PM
Background Colour Depending On Input Macca Excel Discussion (Misc queries) 1 April 30th 06 01:05 AM
Summing a range if a certain background colour Inserting an option button in Word Excel Programming 7 June 21st 05 03:12 PM
Sum depending on cell background color gwag17 Excel Programming 3 July 12th 04 02:24 PM


All times are GMT +1. The time now is 07:37 AM.

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"