Tracy van der Schyff

#Office365Challenge – Excel Conditional Formatting – Top to Bottom Rules. As mentioned yesterday, Excel has many options when it comes to Conditional Formatting. Yesterday we worked with Highlighting Cell Rules. Today we’ll take a look at Top to Bottom Rules.

Related posts:
Around the Office in 365 Days – Day 34 – Highlighting Cell Rules

Highlight the text in your spreadsheet (1), click on the Home Tab (2), Conditional Formatting (3), then on Top to Bottom Rules (4).

These include (5):

1. Top 10 items…
2. Top 10%…
3. Bottom 10 items…
4. Bottom 10%…
5. Above average…
6. Below average…
7. and more…

I don’t see the need to explain all of these to you – but I can say that this is by far the fastest way to do quick analysis on your data.

Below I chose Above Average and these are my results. I’m sure that would have taken me MUCH longer to determine if I’d tried to do it “manually”.

Pretty amazing right??!!

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.

Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.