calculating by color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to calculate various total depending on the color of the data entered

scenario: row of mixed numerical data. there is no pattern for the data. at the end of the row there are four cells that need totals to be placed in them from the cells in the row with certain colors. take for example a time sheet for a job...one color for sick days, another for vacation, holidays, etc...is it possible?
 
Tamesh,

See my reply a couple of days ago at
http://tinyurl.com/379lx

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Tamesh said:
Is there a way to calculate various total depending on the color of the data entered?

scenario: row of mixed numerical data. there is no pattern for the data.
Click to expand...
at the end of the row there are four cells that need totals to be placed in
them from the cells in the row with certain colors. take for example a time
sheet for a job...one color for sick days, another for vacation, holidays,
etc...is it possible?
 
Thanks for the help it works great. Sorry for the repeat of older thread. I guess my search criteria wasn't specific enough.
 
Back
Top