Categories
Excel

Working with Excel

Conditional formatting

This can be found on the Home > Style > Conditional Formatting.

Excel Conditional Formatting

Whenever you want to want to use a formula, I found it easier to do this trick. Create the formula next to the column you want to apply the formatting. In the case below, I want to check if the value is greater than 100 (=A2>100, =A2>100 etc)