Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

coloured cell calculations

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

Coloured Cell Calculations

ResolvedVersion 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:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.