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 →

New member of staff… new security risk?

New employees are a prime target for cybercriminals. They don’t know the ropes yet, and the chances of them becoming a victim are high. Here’s what smart businesses are doing about this problem…

Windows 11 will warn you if someone’s snooping

Windows 11 Onlooker Detection will warn you if someone’s snooping

You know that feeling that someone’s looking over your shoulder?
When you’re working, it’s not just creepy, it’s a security issue. But Microsoft’s working on a very cool feature in Windows 11 that will stop people snooping at your work. Here’s what we know so far…

It’s time to say goodbye to traditional passwords

Say goodbye to traditional passwords, say hello to Passkeys

Passwords could soon be a thing of the past, thanks to Passkeys. If you hate passwords, our latest tech update will make your day…

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.

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.

How future proof is your business’s IT?

Your business’s tech might be working well today, but is it ready for tomorrow? A new study has found more than 60% of business leaders aren’t confident about theirs. What about yours?

5 steps to help recover from a cyber attack

Read this BEFORE you get hit with a cyber attack The worst time to decide how to deal with a cyber-attack is when you’re in the middle of one. Unfortunately, you’ll probably need to deal with it eventually—small and medium-sized businesses are prime targets for...

Why you’re better off in a contract with your IT company

Imagine this: Your business stops working due to a tech issue like malware, data loss or computer malfunction, resulting in a loss of productivity and revenue. Now, think about your current IT support situation. Do you have an IT support contract, or do you only call...

The secrets to make your laptop battery live longer

Ever been caught out by a low laptop battery at the worst possible time? Here’s our professional advice to prolong your laptop battery’s lifespan.

Never mind “can’t teach an old dog new tricks”…

They say you can’t teach an old dog new tricks, but what happens when it’s a young pup that needs training? New research on people under 40 has revealed a scary attitude towards cyber security. We tell you more here.

More Content