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 →

Bridging the trust gap between your employees and AI

Have you noticed your employees are reluctant to use AI in the workplace? It may be down to their lack of trust. We explain how to show them AI is a tool that makes work better for everyone.

Tech Tip: How to use cross references in Word

Today's Two Minute Tech Tip is another tip for Microsoft Word. If you use Word to write documentation, contracts or any other type of detailed document, then this tip is for you. Usually, when you write such a document, you need to refer to other places in the...

What’s your business’s view on Return to Office?

Do you love keeping your employees happy by allowing them to work remotely? Or do you think everyone is more productive in the office? Businesses are divided on this right now… here are some important considerations before you decide what’s best for your team.

Are you using Teams to share sensitive data?

Microsoft Teams has fast become one of THE most useful business tools for the way we work today. No matter where your people work from, they can communicate and collaborate quickly and reliably. But this remote way of working can also open the door to some MAJOR security issues. New research shows that nearly HALF of employees frequently share confidential …

Beware the next generation of phishing attacks

Most phishing scams still feel a little… amateur.
But the next shift is dangerous.
Attackers are changing how scams are built, not just how they’re sent. And the signs people have been trained to look for won’t always be there anymore…

Young employees have different attitudes to cyber crime

If you employ anyone aged between 16 and 19, you need to pay special attention to the cyber security training you’re giving your team.

Beware these free tools – they may be hiding ransomware

Need to change a file from one format to another? Easy, just Google a file converter, right? Stop! That may not be as safe as it seems. Find out why here…

Half of staff have too much access to data

Do you know who in your business can access your critical data right now?
The risks that come along with that can be bigger than you think. Our latest tech update explains why this matters and what smart businesses are doing about it…

A third of all data loss is caused by problems with backups

The lack of a reliable backup causes a third of all data loss

Your business data is backed up and recovery tools are in place. So, your data is safe, right? Sadly… not always. Here’s why we recommend backups are checked regularly..

IT Security Still Top Concern For SMBs

A new report from Kaseya reveals that IT Security is still the top concern for small and medium-sized businesses. The “2019 State of IT Operations for Small and Midsize Businesses” survey took input from more than 400 global respondents and reveals that 32% of...

More Content