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

Tech Tip: How to Provide Remote Support for FREE with Quick Assist

This Two Minute Tech Tip shows you how to view or control someone else's screen for FREE. As an IT managed service provider we have lots of tools we have to pay for to help us support our clients. However, if you've ever been in a situation where you are trying to...

Are you really downloading Zoom – or is it malware?

When you think about tools for remote working and chatting online, one of the first names in your mind is Zoom. But its popularity has opened the door for cyber criminals. They’re using its name to steal sensitive data. Researchers have discovered at least six convincing-looking download sites. They’re not the real thing. They’re designed […]

Get ready for another game-changer from Teams

Microsoft is working hard to lead the AI revolution and its latest update to Teams will certainly make it a front-runner. We think the potential is unlimited, here we’ll tell you why.

Copilot is bringing another productivity boost to Teams

Copilot is bringing another productivity boost to Teams

Teams is getting some Copilot-powered updates that will boost your business’s productivity even further. Here we tell you all about it.

HRMC Crown

The tax relief few businesses know about

A quick summary: When you buy certain new equipment (including computers) you can claim 130% capital allowance What that means: If you spend £1,000 on computer equipment, it'll reduce your corporation tax bill as if you had spent £1,300 How long does it last? It will...
Windows 10 is getting a very useful Windows 11 feature

Windows 10 is getting a very useful Windows 11 feature

There’s no denying that Windows 11 has a lot of really cool new features. If you haven’t made the move from Windows 10 yet, you’re missing out. But there’s good news. To make the (eventual) move from Windows 10 to 11 a little easier, Microsoft is sharing a couple of...

Is your security focusing on the right things?

A new study shows that only a third of businesses place detection as their main priority, while two thirds say prevention is their primary focus.

Cyber extortion: What is it and what’s the risk to your business?

Cyber extortion: What is it and what’s the risk to your business?

Have you heard of cyber extortion? It’s a very real threat to your business. Here we explain what it is and how to stay safe.

Bonus Guide: The Crowdstrike Outage Explained

Download our free guide summarising everything you need to know about the recent Crowdstrike outage. This is written specifically for business owners and managers. Inside, you’ll discover: What CrowdStrike is What happened on Friday 19th July 2024 The impact of the...

Getting to Grips with Email Security

Owners of small and medium-sized businesses often make the mistake of thinking that they aren’t on the criminals’ radar. But more than 40% of cyber attacks are aimed at small businesses – and email is usually the criminals’ way in. Our new guide, ‘Getting to Grips...
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