General Excel and formatting

Resolved · Low Priority · Version 2016

Thu 5 Sep 2019, 16:39 Delegate Dave said...

Dave has attended:
Excel Intermediate course

General Excel and formatting

Can you autosum on a certain formatting ie bold? Instead on manually selecting cell references?

Thu 5 Sep 2019, 18:01 Trainer Jens said...

RE: General Excel and formatting

Hi Dave,

Thank you for the forum question.

It is only possible by VBA coding in Excel, but I have a feeling that you may be can use the Sumifs function to do what you want.

The Sumifs function can summarise if something is true, but it cannot work with colours.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips