How can we help?

Close
icon

Give us a call

Our team of experts are on hand and ready to help.

0161 883 2655
icon

Live chat

Ready to chat data? That's what we're here for

icon

Submit an enquiry

Fill out your details and one of the team will be in touch

Get in touch

Conditional formatting in Excel allows you to format a single cell or group of cells according to the data within them. In Excel you can chose to format a cell with highlights, data bars, colour scales or icons due to the rules that you can set; ultimately opening up endless data visualisation possibilities.

If you want to add a colour scale to a set of data you need to highlight the cells you want to apply it to.

Conditional Formatting

Then click on the conditional formatting tab.

Conditional Formatting

Then colour scales and select the colour scale you want.

Conditional Formatting

You can also use data bars and icons.

4 5

You can also use conditional formatting to highlight duplicates.

6 7