This can be achieved using the IF function in Excel.

In cell F5, the result is TRUE because C5 contains 85.

The result returned by the IF function can be customized as needed.

Using conditional formatting to highlight scores greater than 80

The formula used to highlight scores greater than 80 is:

The formatting is automatic.

If a score is changed to a number greater than 80, the yellow highlighting will appear.

you’ve got the option to find more conditional formatting exampleshere.

Using conditional formatting to highlight scores greater than 80

More than one condition can be tested by nesting IF functions.

The IF…

The IF function

If this OR that

Using conditional formatting to highlight scores greater than 80

Using conditional formatting to highlight scores greater than 80

Using conditional formatting to highlight scores greater than 80

Excel formula: If cell equals

Excel formula: If this AND that

Excel formula: If cell is this OR that

Excel formula: If NOT this or that

Excel formula: If cell contains

Excel formula: Nested IF function example

Excel IF function

Article image

Article image