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

How many devices do you use every workday?

Gadget overload? How many devices do you use at work?

Are all the devices your team uses helping them stay productive – or hindering them? Every extra gadget means another thing to remember, charge, and carry. There’s a simple way to help streamline tech in your business…

1 in 4 people struggle with password overload. Here’s the answer

1 in 4 people struggle with password managment. Here’s the answer

Struggling from password overload? You’re not alone, and it’s putting your business at risk of data theft. Good news: There’s a very simple solution and we’ll tell you all about it.

Say goodbye to video call pop-ups (and Teams meeting blushes)

Say goodbye to video call pop-ups (and Teams meeting blushes)

Has a pop-up notification ever embarrassed you while you were on a video call? Microsoft may finally have a feature to stop that happening. Learn more here.

Tech Tip: How to use Mail Merge

This Tuesday Two Minute Tech-tip shows you how to automate customised emails and letters using Mail Merge. Imagine; you need to send a letter or email to 10s, or even 100s of people with the same base content, but personalised for each recipient. You could manually...
Pirated software thumbnail

Don’t walk the plank with pirated software

A huge number of small and medium-sized businesses would consider using pirated software to try and save money. Don’t do it.

Tech Tip: How to find the tools you need in Microsoft Office

Welcome to a new Tuesday tech tip video, and it's another speedy, but useful one Are you struggling to find the tools you need in Office applications? Me too! Since Microsoft introduced the ribbon in Office applications, it has become harder to find tools that you...
Windows 11 on a Laptop Screen

What’s coming in Windows 11?

Microsoft has just announced (in a typically 'West Coast'​ way) what's coming in Windows 11.  Here is a rundown of what was announced at the event. Windows 11 Interface Design The first impression visually is that it looks kind of like Linux merged with Mac OSx. The...

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...

Cut the Jargon! The top 3 things you should discuss with your IT partner

IT support involves technical tasks, and the language used in this field can be quite technical at times. Therefore, we have created a plain language guide that focuses on the three key areas you should discuss with your technology partner. Contact us if you want to...
Save time by accessing your Android phone’s files with File Explorer

Save time by accessing your Android phone’s files with File Explorer

A new feature in Windows 11 may make accessing files on your Android phone much quicker. We have all the details.

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