Excel

[richb14]

I want to make a spreadsheet where get an amount added to a total when I paste a cell. For instance, I want to paste a coloured cell (that represents 15mins) into 4 cells. This would total an hour. How would I set excel up to do this so that in a different cell, i.e. the total cell, the total of all cells with that partiular colour gets added up.
Thanks Rich.

[camioneur]

i was looking for something alonng similar lines a while back. i was told that excel cannot use colours or formats to determine a formula, merely values. You might need to get into the visual basic to do this but i'm afraid that's beyond me

[mg17475]

Yes camioneur is correct the only way excell can do this is if there are some values in the actual cell, so that teh conditional format can recognize the numbers and chaneg the format of the cell

[Machecoul]

If I understand the question this might work:

if you type 15 in the cell and change font colour to blue and then fill cell in blue - the colour won't show up but the value will be there just hidden.

You might even be able to use conditional formatting to help with the colouring.