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

conditional format

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional format

Conditional format

ResolvedVersion 2016

Arif has attended:
Excel Intermediate course

Conditional format

How to use

RE: Conditional format

Hi Arif,

Thank you for the forum question.

Conditional formatting is a very powerful way of visualise specific information in your worksheet. It can be trends, deadlines, targets, and much more. The logic is if a test you create is true the data will be highlighted.

I found a good video, which explain how to use conditional formatting.

https://www.youtube.com/watch?v=lIqifDg2xfE


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

Thu 15 Aug 2019: Automatically marked as resolved.

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

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.