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](https://www.excel-pratique.com/view/en/course/img/excel_conditional_formatting_examples/cf_equal.jpg)
Enter ="UNPAID"
and define formatting.
![cf unpaid excel conditional formatting examples](https://www.excel-pratique.com/view/en/course/img/excel_conditional_formatting_examples/cf_unpaid.png)
Repeat the above action with ="PAID"
.
![cf paid excel conditional formatting examples](https://www.excel-pratique.com/view/en/course/img/excel_conditional_formatting_examples/cf_paid.png)
This will be the result:
![cf paid unpaid excel conditional formatting examples](https://www.excel-pratique.com/view/en/course/img/excel_conditional_formatting_examples/cf_paid_unpaid.png)
Source file: cf1.xlsx
2. Display Payment Delays Based on Today's Date
![cf date excel conditional formatting examples](https://www.excel-pratique.com/view/en/course/img/excel_conditional_formatting_examples/cf_date.png)
Using the TODAY, CF will use today's date to determine whether payments are late.
![cf delays excel conditional formatting examples](https://www.excel-pratique.com/view/en/course/img/excel_conditional_formatting_examples/cf_delays.png)
Source file: cf2.xlsx
3. Display Duplicates
Choose the "Duplicate Values..." CF:
![cf duplicates excel conditional formatting examples](https://www.excel-pratique.com/view/en/course/img/excel_conditional_formatting_examples/cf_duplicates.jpg)
Define formatting.
![window cf duplicates excel conditional formatting examples](https://www.excel-pratique.com/view/en/course/img/excel_conditional_formatting_examples/window_cf_duplicates.png)
The duplicates have been highlighted.
![display cf duplicates excel conditional formatting examples](https://www.excel-pratique.com/view/en/course/img/excel_conditional_formatting_examples/display_cf_duplicates.png)
Source file: cf3.xlsx