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.

← Protecting your data - Backup and Restore Tech Tip: How to get the most out of Google searches →

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...

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.

Tech Tip: How to managed Focused and Junk email in Outlook

Welcome to a new Tuesday Two Minute Tech Tip that will help you to manage what you see in your Inbox. Are you wondering where your emails have gone? Is something you expect to see in your Inbox not arriving anymore? This video will show you how to: 👉...

IT Managed Services for Financial Services

Over the last four decades, technology has significantly impacted how Financial Services operate. In the past, Financial Services businesses, such as IFAs and accountants, had to track financial data manually. Today, they can use software to automate many of these...

IT Managed Services for Law Firms

Over the years, technology has shaped and changed legal firms in the UK in many ways. Technology has helped legal firms to go digital and provide a streamlined client experience by allowing them to access case files online from anywhere. Technology has also helped...

Are you using the all-new Teams yet?

Tired of waiting for Teams to load? Microsoft has heard your frustration and has rebuilt it from the ground up. The all-new Teams is faster and uses less memory; we give you all the details

Let’s start talking about Artificial Intelligence (AI)

From Alexa to Siri, AI is already all around us, but names like ChatGPT, Dall-E and Jasper have blown up the internet. Let’s decode some of the language

Tech Tip: How to name cells in Excel

Welcome to a new Tuesday tech tip video where I will show you how to name cells in Microsoft Excel. Naming cells can make your spreadsheets easier to understand and maintain and help you write more concise and efficient formulas. In the video, I show one way of doing...

Uh oh! You’re at greater risk of malware than ever before

Small and medium-sized businesses are at more risk of a malware attack than ever. It’s time to take action to protect your business. Here we tell you how.

Tech Tip: How to add your availability to an Outlook Email

Today's Tuesday Two Minute Tech Tip will save you time when arranging meetings. Are you wasting time when trying to book meetings by constantly going back and forth with people trying to find a suitable time? There is a better way to find time for a meeting by using...

More Content