A more recent version of the Excel course is available here: Excel Course

Excel Course: Conditional Formatting (examples 1 to 3)

Examples of Conditional Formatting

Here are some examples of CF including source files.


1. Show "paid" in a cell when date of payment is entered

Select target cells and choose the "Equal to..." CF:

cf equal excel conditional formatting examples

Enter ="UNPAID" and define formatting.

cf unpaid excel conditional formatting examples

Repeat the above action with ="PAID".

cf paid excel conditional formatting examples

This will be the result:

cf paid unpaid excel conditional formatting examples

Source file: cf1.xlsx

2. Display Payment Delays Based on Today's Date

cf date excel conditional formatting examples

Using the TODAY, CF will use today's date to determine whether payments are late.

cf delays excel conditional formatting examples

Source file: cf2.xlsx

3. Display Duplicates

Choose the "Duplicate Values..." CF:

cf duplicates excel conditional formatting examples

Define formatting.

window cf duplicates excel conditional formatting examples

The duplicates have been highlighted.

display cf duplicates excel conditional formatting examples

Source file: cf3.xlsx