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 →

Searching in Windows 11 is about to get easier… for some

Searching for files in Windows isn’t always a smooth experience. Sometimes it’s slow and often it’ll show you web results rather than the file you need. But Microsoft is making things much simpler… for some people. Here’s how you can benefit from this.

Now AI can make your Teams meetings more productive

Microsoft Teams Meeting Recap will summarise your meetings and even make a list of the action points. We show you its other benefits

What is Proactive Monitoring and how can it protect your business?

How proactive monitoring will help your business weather any storm. You are the captain of your business's ship. You have a loyal and skilled team behind you. You are ready for any challenge! Or so you thought. Then, one day, without warning, a vast digital monster...

Are your employees reporting security issues fast enough… or even at all?

The faster your employees report a potential cyber security issue, the less damage is done to your business. But how can you encourage quick reporting? Here we share some solid ideas.

Microsoft Edge introduces a new scam protection tool

Those fake “your computer is infected” pop-ups are getting smarter. And scarier.
But there’s some big news from Microsoft that could make them a thing of the past.
This update to Edge is changing how your browser fights back against online scams…

This tiny tweak to Teams will make meetings smoother

Sick of saying “next slide please” in your Teams meetings? Microsoft has a small but powerful new feature that will put an end to that. Find out more here…

A handshake reaching out of a laptop screen

What is a managed service?

If computers are an essential part of your business you will probably have someone looking after them for you, but what type of service are you getting from them? Have you heard the expression "Managed Service" or "Break/Fix"? You may have heard these expressions and...

Teams update: No more accidental quitting

Ever noticed how it’s the tiny software quirks that cause the most frustration?
If you live in Microsoft Teams meetings, there’s a subtle change rolling out that could make things feel noticeably smoother.
It’s one of those updates everyone will appreciate…

Is your team using AI well? Copilot can tell you

You’ve adopted Copilot in your business. You know the potential benefits are huge.

But is your team as enthusiastic about using it as you are?

This new feature will tell you…

SHOCK STAT: A third of business owners don’t trust their staff

Do you trust your employees with sensitive business data? You might be shocked to learn how many business owners don’t. But why… ? We have the answers.

More Content