Building Logical Formula under Conditional Formatting

This involve building rules to satisfy some condition using different criteria. In a table below I want to build a formula that will highlight the entire rows that have the same transactions date with the date supplied in cell A3. To do this is very simple. All you need to do is to follow the[…]

Shares 0

Conditional Formatting: Top / Bottom Rules

Under this we can highlight the cells that hold highest values or least ones, top percentages or bottom percentages, and above average or below average. Let’s applied Top/Bottom Rules on the given data set below. To highlight the TOP 3 values in the range. Highlight cells range B3:B10 Go to Home menu >> Conditional formatting[…]

Shares 0

Conditional formatting: Highlight Cells Rules

Here you can highlight cells that either greater than, less than or equal to a value. It also allows us to highlight cells than contain specific text, value in between, duplicate to mention few. Let’s illustrate how Excel highlights cells that hold values that are greater than a particular one. For instance quantity sold that[…]

Shares 0