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.

More Content

Is app overload slowing down your team?

Is app overload slowing down your team?

How many different apps and chat services are your employees juggling every day? Chances are, it’s making your business less productive. Good news: There’s a simple solution. We have the details.

Is your business data at risk? Don’t take chances with old tech

Old computers and external drives can put your sensitive business data at risk.
We look at how to dispose of old computers and external drives in the safest way possible.

Important: Protect your business from digital fraud

Important: Protect your business from digital fraud

Digital fraud isn’t on the rise. It’s evolving. Fast.
Scammers are using smarter tools, more convincing messages and pressure tactics designed to make even careful people slip up.
These are the simple habits that could stop your team from falling for them…

Video thumbnail

Tech Tip: Quickly add lines numbers and bullets in Word

Happy Tuesday everyone! Today's Tech Tip is a tip on how to use some of the formatting shortcuts in Word to add lines, bullets and numbers to organise your documents. If you use Word to write your documents, and 90% of people do, you will love this tip as it will show...
Don’t sleep on this simple, effective security booster

Don’t sleep on this simple, effective security booster

Microsoft’s enforcing an extra layer of security for logins to one of its tools. Even if you don’t use it, you should follow their lead and implement this security booster in your business.

Logos for Microsoft 365

The Microsoft New Commerce Experience (NCE) is on the way

Microsoft is introducing what it calls a New Commerce Experience (NCE) in 2022, with changes to licensing terms and pricing for Microsoft 365. This will mean fairly big, and potentially expensive, changes for business customers who have Microsoft 365 licences. The...

Time to move your business to the cloud?

Still relying on office computers? It’s time to move your business to the cloud. A few years ago, running your business using data and apps stored on office computers—or a dusty server in the cupboard—might have worked. But times have changed. With remote teams and...
How to create secure passwords

How to create secure passwords

Weak passwords are one of the biggest security risks to your business.
Why?
Because cyber criminals are getting smarter than ever before. If they manage to crack just one password, they could gain access to your sensitive business data, financial information, or even gain control of your entire system.
Cyber criminals use automated tools to guess passwords, allowing them to try out millions of combinations in seconds. So, if you’re using something like “Password123” or “CompanyName2025”, you’re practically handing them the keys to your business.
A compromised password can lead to big issues, such as:
• Data breaches
• Financial losses
• Identity theft
• Reputation damage
But how do you create strong passwords without driving yourself (and your team) mad?
Think of your password like a secret recipe, where only you should know the ingredients. It should:
• Be at least 14 characters long (the longer, the better)
• Include a mix of uppercase and lowercase letters
• Contain a few numbers and symbols (like @, $, %, or &)
• Not contain any common words or easily guessable information (like birthdays, names, or the word “password”)
Instead of using a single word, you could try a passphrase – a short, random sentence that only you would understand. For example, instead of “Sailing2025”, try something like “Coffee&CloudsAreGreat9!”. This is much harder to crack, yet still easy to remember.
You should also steer clear of these common mistakes:
• Using personal info (your name, birthday, business name, etc.)
• Reusing the same passwords across multiple accounts
• Using simple sequences (“123456” or “abcdef”)
• Storing passwords in an easily accessible place (like a sticky note on your desk)
If remembering unique passwords for every account sounds impossible, there is another option: Password managers. These generate strong passwords, store them securely and autofill them for you.
With a password manager, you only need to remember one strong master password for the manager app itself. The rest are encrypted and stored safely, reducing the risk of data breaches.
Even the strongest password isn’t foolproof, which is why multi-factor authentication (MFA) is also important. MFA requires a second form of verification, like a one-time code sent to your phone or generated from an authentication app.
If you have employees accessing your business systems, it’s a good idea to have a password policy in place to explain your rules and why they’re important. This should include:
• Unique passwords for each system and account
• Regular security training on password best practices
• Business-wide use of MFA for critical systems
• Scanning for compromised passwords regularly
By making password security a priority, you can reduce the chances of a cyber attack creating a nightmare for your business.
And if you need help making your business more secure, get in touch.

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

A laptop and tablet taking a backup

Two simple steps to protect your business data

Data is the lifeblood of most modern businesses.  From important proposals and presentations to a simple one-line email that is proof of something happening that you might need months later.  However, many small businesses are not taking the necessary steps and...
Share This
Contact
Love Lane
Cleobury Mortimer
Shropshire DY14 8PE

01299 382 321
[email protected]
Copyright © Blisstech Solution Ltd
Registered No: 08125391 VAT No : 307 5490 05