conditional format

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

Conditional format

resolvedResolved · Low Priority · Version 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:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

View all Excel hints and tips


Server loaded in 0.06 secs.