FREE CHEAT SHEET
All the key points in one handy PDF
Plus, collect a FREE copy of our 30 Excel Power Tips.
Enter your details for immediate access.
Conditional Formatting is a very useful, powerful and versatile tool. As its name suggests, it has two parts - a condition and a format. When the condition is true, the format is applied.
You can check for all kinds of things. You can also apply a multitude of different formatting options ranging from basic cell colours and font colours to coloured data bars, colour scales (heat maps) and even icon sets.
Moving past the basics you can set a condition based on a formula and that’s what we’ll be doing in this cheat sheet example.
The Conditional Formatting tool is available on the Home tab.
Consider this worksheet. Every ‘Category A’ row has been highlighted automatically.
Here’s how it's done.
To test the formula, whenever the category in column A is "A" every data cell in that row is highlighted automatically.
Have you used conditional formatting in interesting ways?
Please share your thoughts and feedback in the comments below, and if you found this post useful, please share a link on your social networks.
Cheers. Here's to your learning and success. Enjoy the rest of your day.
Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.