coloured cell calculations

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Coloured Cell Calculations

Coloured Cell Calculations

resolvedResolved · Medium Priority · Version 2007

Amy has attended:
Excel Advanced course
Word Advanced course
PowerPoint Intermediate Advanced course

Coloured Cell Calculations

Within a range of cells that includes text rather than numbers which are colour coded to the indiduval cell is there a way to automatically calculate the total rather than having to manually calculate the total?

Thank you for your help, please let me know if you wish to see the report I am working on.

RE: Coloured Cell Calculations

Hello Amy,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding Coloured Cell Calculations.

It would a good idea for me to see the file you are working on, so shoot it over to me at:

rl@stl-training.co.uk

I look forward to hearing from you.



Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

RE: Coloured Cell Calculations

Hello Amy,

We are busy clearing out the older and potentially unresolved forum questions, so just checking to see if you got your question resolved.

If not, please would you send your file to forum@stl-training.co.uk and we will take a look at it.

Kind Regards,

Richard

Mon 4 Nov 2013: Automatically marked as resolved.


 

Excel tip:

Quickly select a block of data

To quickly select a block of data make sure your active cell is somewhere whithin the block of data and then press Ctrl+* or Ctrl+Shift+8.

View all Excel hints and tips


Server loaded in 0.1 secs.