how do i do conditional formatting in excel

Bottom 10% (highlights the lowest 10% of values, although with a small sample it'll round down the to nearest integer, so with only 15 values, it'll only highlight one value, at 20 values, it'd highlight two).

Bottom 10 items (Highlights the lowest 10 values in the data range).

Top 10% (highlights the top 10% of values, although with a small sample it'll round down the to nearest integer, so with only 15 values, it'll only highlight one value, at 20 values, it'd highlight two).

Top 10 items (highlights the highest 10 values in the data range).Here is an example of the greater than rule being used: Top/Bottom Rules Duplicate values - (see if there is more than one of the same value in the selected range).A date occurring (highlights a singular date, unfortunately not available as a preset for a date range - see custom rules/new rule later in this guide).Text that Contains (if you're looking for a word in a range, instead of a numerical value).Equal to (select an exact value, must be an integer).Greater than or less than (a separate option for either).This option highlight cells with the following criteria: Icon sets- Multiple icon sets to show changes up, down or remained the sameĪn image of the conditional formatting menu: Highlight Cell Rules.There is also the option for 2 colour or 3 colour scales. There are multiple different colour scales available moving from low to high values.

Colour scales - A colour scale based on the value found in the cell.Data bars - A scaling bar that increases across the width of a cell as the value increases, this is useful for: Seeing comparatively a cells value in relation to other cells in the column or row.Top/Bottom rules - This will automatically highlight the highest or lowest, or both simultaneously in a range of data.This will formatting the cell with criteria met. Highlight cells - Allows you to highlight cells that have a greater than or less than value, between a certain value or equal to a value or text or date matches as well.

In this drop down menu you will find a bunch of preset designs using: This can help you visualise the data faster than reading off the values using colour schemes and icon sets to show the quantities or differences between values more effectively than numbers would at a glance.Ĭonditional formatting drop down menu can be found in the home tab: Mainly surrounding different ways of displaying data corresponding to the value found within the cell or range of data. AdviseU: Student Wellbeing Adviser TeamĬonditional formatting is a feature that has a variety of uses.

How do i do conditional formatting in excel