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

Download PDF files of this course