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

Bring Your Own Device: Dos and don’ts for your business

Do you let employees use their own phones, laptops, or tablets for work? That includes things like sending a quick email or updating a client account. If you do, it’s important to remember that personal devices often lack the security measures of work-issued devices....
Which ransomware payment option is best? (Hint: none)

Which ransomware payment option is best? (Hint: none)

Cyber criminals are giving you more options when it comes to paying your way out of a ransomware attack. Our advice remains the same though. Find out what that advice is here.

Don’t forget your phone when you think about cyber security

Our phones are a goldmine of private information. If they’re not as secure your other devices, they can become a gaping hole in your cyber security

How to cheat (the Blue Screen of) Death

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.

Charging in public places? Watch out for “juice jacking”

Airports, hotels, cafés, even shopping centres, offer public charging points where you can boost your phone or laptop battery on the go. They’ve been in the news after the FBI recently tweeted advice to stop using them. Crooks have figured out how to hijack USB ports to install malware and monitoring software onto devices as they charge. The security risk …
Read More

Some bosses think their people do less when working from home

Microsoft has become the leader of productivity over many decades. Can you imagine doing your day to day work without their software? So it’s no surprise the tech giant recently conducted a major new survey into productivity in the workplace – and some of the results might surprise you. Researchers surveyed 20,000 people working for […]

A woman on a laptop with a shield and lock on the screen

Why you should use a password manager

Introduction It can be difficult to keep track of all of your online passwords, especially if you have multiple accounts for different purposes.  But did you know that there is a way to keep all of your passwords safe and secure? A password manager such as LastPass...
Don’t think your business is a target? Think again

Don’t think your business is a target? Think again

Cyber criminals are targeting businesses of all sizes, all the time. And new research shows just how they’re doing it. We tell you how to stay protected.

Are your productivity tools actually slowing you down?

If productivity tools aren’t embedded properly within your business, tasks can actually end up taking longer than they should.

Tech Tip: How to align in objects in Microsoft PowerPoint

In today's Tuesday's Two Minute Tech Tip Matt shows you how to align objects in PowerPoint. It can be a pain when trying to align things manually in PowerPoint, but there is a handy little feature that makes this easy. This video will show you how to: 👉 How to quickly...
Share This
Contact
Love Lane
Cleobury Mortimer
Shropshire DY14 8PE

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