Computer Tutoring Logo
Est. 2002
Menu Button

Using Conditional Formatting in Excel - Online IT Training


Having looked through the list a number of times you still can't find where the problem is. What is more you do this every week and it's wasting time. Conditional formating can change the colour of a cell based on the data that is in it. This online IT training video will show you how.

Use the if function file for the conditional formatting exercise.

You may have to click on enable editing in Excel to be able to complete the exercise.

Computer Tutoring takes your privacy seriously and collects essential information such as your name, email, and course preferences to facilitate our services. Additionally, we use cookies to personalise your experience and for Google Ads personalisation, which helps us deliver more relevant advertising to you.

We do not share your personal data, except for specific use-cases like payment processing via PayPal and sending you updates via Mailchimp, if you've opted in for those services. Our site may also use Google Analytics to improve user experience and features links to other websites. Please be aware that Google's Privacy Policy may differ from ours.

We do not store your credit/debit card details. You have the right to access, amend, or request deletion of your personal data by contacting us at

By using our website, you consent to our use of cookies for the purposes outlined above.

For more details, please read our full Privacy Policy.