LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 47
Default add total only shaded cells

Hi everybody,

Can anyone help.
I have a formula that colors the cell which is less, how can I add only the
colored cells?

Example; Collumn "A" & Collumn "B" with 100 rows each, entered a formula
to highlight with a color the <cell. Is there a way to add the value of the
colored cell only?

Please help!
--
smile
 
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
Shaded cells won't print shaded Linda C Excel Worksheet Functions 4 April 3rd 23 06:59 PM
How do I get gridlines in shaded cells? Joemerald Excel Discussion (Misc queries) 1 February 13th 07 06:04 PM
linking shaded cells Roz Excel Discussion (Misc queries) 2 January 24th 07 04:39 PM
How do I count shaded cells Randy Excel Worksheet Functions 19 February 3rd 05 11:35 PM
Selecting shaded cells in a row Al Excel Worksheet Functions 5 January 25th 05 05:31 AM


All times are GMT +1. The time now is 04:20 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"