Excel question

[marine1]

Hey techies need some help.
I have a workbook that has days and dates and has people's names for day / night shifts on the workbook.
There are 3 people, there names in their respective shifts.
Each person has his own colour background for for easy identification.
There are not set shifts and some people work double shifts or not at all depending on the circumstances.
Is there a way to have totals on the side using some formula, using colours to give the total?

Basically instead of using columns or rows, surely there must be some way to have totals that use colours for the actual total??
Thanks guys

 

[Sting]

Conditional formatting?

 

[marine1]

I have no idea?

 

[pmbellis]

You're not very specific in what you have and what you need, so it's difficult to know how to help you.

1.) What version of Excel are you using
2.) What is the layout of your spreadsheet (what data is in each column, etc)
3.) HOW is your day/date data input and formatted? (If it's text info it'll have to be massaged to data/time data).
4.) What totals are you looking for? No. of shifts, no. of hours, etc
5.) When you say colours, don't you want to see the data, or do you want to see the data in a specific [changing] colour?

 

[Drake2007]

Not without using VBA

 

[crazy_cat]

Not without using VBA

thats like a four letter word to me

 

[greggpb]

in Office 2007 you can auto filter by colour so you could probally do..

 

[Borrels]

Not without using VBA

Unfortunately true. Here is how to do it:
http://www.meadinkent.co.uk/excel-color-calcs.htm

But marine1's question is a bit vague. Do you want the total to display a colour, based on the value? Then conditional formatting is your answer. If you want to add all values from cells with the same colour, you'll have to go with the above VBA macro; although it may be easier to restructure your sheet enable an easy formula/pivot table without having to do VBA.

 

[PallBearer]

i think what he actually wants to see is the time/date worked - relayed onto a day planner kind of thing (like a project planner)

so if the guy worked 4 hours last night and the super looks at this file, then the four hours would be highlighted and the rest all normal.

simply use conditional formating!