Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 7th 05, 03:59 PM
MA
 
Posts: n/a
Default Excel - formula to calculate colored fill cells within a range wi.

I am making a report that is by province and have highlighted all the cell in
the coloum in the color fill that is assigned to that province. I want to
do a formula that will add all the colored cells for each province without
having to manually go and select the colored cells for the answer...is there
a way to have the formula reconqnize the color only for the answer for within
the range??? Would save a lot of time....

  #2   Report Post  
Old January 7th 05, 04:06 PM
JulieD
 
Posts: n/a
Default

Hi

check out http://www.cpearson.com/excel/colors.htm for ideas on working with
colours

Cheers
JulieD


"MA" wrote in message
...
I am making a report that is by province and have highlighted all the cell
in
the coloum in the color fill that is assigned to that province. I want
to
do a formula that will add all the colored cells for each province
without
having to manually go and select the colored cells for the answer...is
there
a way to have the formula reconqnize the color only for the answer for
within
the range??? Would save a lot of time....





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
Adding contents of cells by clicking in Excel 2002 Kevin Gordon Excel Discussion (Misc queries) 7 January 11th 05 04:49 PM
Formula displays does not calculate Neil Bhandar Excel Discussion (Misc queries) 4 January 10th 05 10:55 PM
I need help getting Excel to auto-fill cells when I begin typing . todd New Users to Excel 2 January 7th 05 03:07 PM
Excel 2003 - Formula result shows as 0:00 Serena Excel Worksheet Functions 4 November 11th 04 10:18 PM
stop excel from shifting cells up when a query returns no data DrLostinExcel Excel Worksheet Functions 2 November 9th 04 05:44 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017