Tech Tip: How to use Conditional Formatting in Excel • Blisstech Solutions

This Tuesday Two Minute Tech-tip shows you how to automatically add pizzaz to your spreadsheets.

Using a feature called ‘Conditional Formatting’, you can automatically format the cells of your Excel spreadsheet based on what is in them.

For example, you can emphasise numbers based on their values so that higher numbers are red and lower are green. Or, you can automatically highlight cells that contain dates inside or outside of a range.

There are lots of things you can do with Conditional Formatting!

This tip will explain:

   👉 What Conditional Formatting is and why you should use it.
   👉 Three cool ways you can use Conditional Formatting.
   👉 How to create basic Conditional Formatting rules.

These tips will help you to:

   💥 Automatically format spreadsheets to make information jump out!
   💥 Find the Conditional Formatting feature and use it.

More Content

Microsoft 365 makes Multi-Factor Authentication easier

Microsoft is planning to enable Multi-Factor Authentication (MFA) directly in its Outlook app for many 365 business users.

Tech Tip: How to create a voting poll using Outlook

Welcome to a new Tuesday tech tip video where we will be exploring how to create a voting poll using Outlook and Microsoft Forms. Sometimes, when we need to get people's opinions on something, it can be a bit like herding cats! Maybe we need to get a consensus of...
Pirated software thumbnail

Don’t walk the plank with pirated software

A huge number of small and medium-sized businesses would consider using pirated software to try and save money. Don’t do it.

Why setting up Facebook Wi-Fi for your business is a good idea

Setting up Facebook Wi-Fi for your business is a great way to increase customer engagement and loyalty. When customers connect to your guest Wi-Fi they can check in to your business on Facebook to gain access rather than entering a WiFi code. This allows them to stay...

Here’s how cyber criminals try to hack your accounts while you sleep

Have you ever received a notification on your phone while you’re sleeping, asking if it’s really you logging in?
It’s called a fatigue attack and Microsoft Authenticator’s latest feature will help to protect you.

3 essential security tools for every business

Your data is one of your most valuable business assets. Keeping it safe should be one of your main priorities.

The final curtain call for Windows 10: What you need to know

Microsoft has announced there will be no new feature updates for Windows 10 so maybe it’s time to upgrade to Windows 11. Our latest video will help you make up your mind.

Are your productivity tools actually slowing you down?

If productivity tools aren’t embedded properly within your business, tasks can actually end up taking longer than they should.

New! A better way to find Chrome extensions

New! A better way to find Chrome extensions

The Chrome Web Store’s been given a massive makeover, and it’s all about making your team’s life easier. We have all the details.

Shady character in a mask sitting by computer screens

A new zero-day vulnerability in Windows

Introduction A new zero-day vulnerability in Windows Search has been discovered which can be exploited to automatically open a malicious search window containing remotely-hosted malware executables. The vulnerability is triggered when a user launches a Word document,...
Share This
Contact
Love Lane
Cleobury Mortimer
Shropshire DY14 8PE

01299 382 321
[email protected]
Copyright © 2023 Blisstech Solution Ltd
Registered No: 08125391 VAT No : 307 5490 05