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

Why all businesses should adopt MFA now

Years ago, Multi-Factor Authentication (MFA) used to be called 2FA, or Two Factor Authentication.  This was made up of: Something you have, like a device that can generate a one-time password (OTP). Something you know, like a password. MFA has extended things meaning...
How to free up disk space on Windows title image

Tech Tip: 3 ways to free up disk space on Windows

Running low on disk space can make your computer run slowly and can cause other problems such as being unable to run applications, install important updates and in some cases cause your computer to crash. This tech tip will show you three ways that you can free up...

Tech Tip: How to create a scheduling poll using Outlook

Welcome to a new Tuesday tech tip video where we will be exploring how to create a scheduling poll using Outlook. You know what it's like when you are trying to get everyone together for a meeting. Trying to find a time that suits everyone can be a real pain! There...
Windows 11 uptake is at an all-time high – what are you waiting for?

Windows 11 uptake is at an all-time high – what are you waiting for?

If you’re still attached to Windows 10, now’s the right time to upgrade. Here’s why…

Why the Cloud is not backup

Cloud computing has revolutionised the way businesses work.  Companies that utilise the cloud will have coped the best with COVID-19 imposed restrictions.  Whether forced to by circumstance or not, businesses are moving from the traditional server in the office to...
A laptop and tablet taking a backup

Two simple steps to protect your business data

Data is the lifeblood of most modern businesses.  From important proposals and presentations to a simple one-line email that is proof of something happening that you might need months later.  However, many small businesses are not taking the necessary steps and...

Tech Tip: How to Tidy up Copied Data in Excel

This Tuesday Two Minute Tech-tip shows you how to tidy up data in Excel spreadsheets. Do you have data in a messy format and need to change it so it is organised? Have you ever received data in Excel or in a text file or Word document and wanted to change it from rows...

Tech Tip: How to add a FROM address in Outlook NEW

Welcome to a new Tuesday tech tip video. In it, I will show you how to add a FROM address (or alias) in the new version of Outlook. Microsoft's new version of Outlook, imaginatively titled Outlook New, is very different in look and feel from the Outlook we've all...
A woman on a laptop with a shield and lock on the screen

7 ways to secure small business IT

It is hard enough running a business without having to worry about how to ensure your computer systems and data are secure from bad guys.  To help you out, we have put together a list of the top 7 things that you should do to secure your small business IT systems. 1....
New phishing scam is smarter than ever… here’s how to protect your business

New Microsoft 365 phishing scam is smarter than ever… here’s how to protect your business

Microsoft is warning business owners that trusted cloud storage services are being hijacked to trick you into handing over your data. Here we tell you what you need to know.

Share This
Contact
Love Lane
Cleobury Mortimer
Shropshire DY14 8PE

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