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 →

Don’t trust AI with this security essential

Are the passwords protecting your business as strong as you think they are?
There’s a growing shortcut that looks clever on the surface, and feels efficient, but could weaken your security without you realizing.
If you’re using AI in your business, this is something you need to understand…

You might hold the secret to data security in your finger

Is your password keeping your data as safe as it could be? Maybe not. And there are new, safer alternatives to try. Here are all the details.

Laptop on a desk with a picture of a hand holding a globe

Get on top of this now if any of your staff are hybrid working

People are increasingly doing their work remotely and hybrid working has become the new norm. Despite the fact that it has been more than two years since many of us were forced to work from home, too many organisations still do not have the appropriate cyber security...

Consider this before using AI browsers at work

Ever wondered what really happens behind the scenes when your team uses an AI-powered browser?
There’s a hidden trade-off between convenience and security that most businesses don’t spot until it’s too late.
And it could affect your sensitive data, your compliance, and even your day-to-day operations…

Windows Hello gets a new look and improved security

Windows Hello gets improvments in security usability

Is your business using Windows Hello yet? It offers easier and more secure login methods – and it’s about to get an upgrade. Here’s what’s changing.

Outlook will flag your most important emails

Your inbox is about to get a powerful new ally. Find out how Outlook’s latest feature could help you cut through the noise of junk and spot the emails that really matter (and save time too)…

Why you will not be fine on this Cloud9

Fake Flash messages are being used as a cover for a new ‘botnet’ campaign. If you use Google Chrome or Microsoft Edge you could be a target.

Tech Tip: An overview of Microsoft Teams

Welcome to a new Tuesday Two Minute Tech Tip that covers the basics of Microsoft Teams. Microsoft Teams has become one of the 'go to' tools for collaboration since the start of the pandemic, but most people are only scratching the surface of what you can do with it....

80% of malware is powered by AI

Cybercrime is evolving fast… and AI is changing the game for both hackers and how we defend against them. Is your business ready for this?

The Blue Screen of Death and how to avoid it

The dreaded Blue Screen of Death makes you panic about what happened, how much work you’ve lost, and how long it’ll take to fix. But a lot of the time it’s avoidable… We’ll tell you how.

More Content