Conditional Formatting allows changing appearance (different color, font, format etc) of cell based on certain condition. For example you can show employees with Salary Higher than 100000 USD in Red. This makes easy and visually appealing to read and interpret data.
Try this example below to better understand the concept. Enter Data below in Excel
| Emp No | Designation | Salary |
| E001 | Manager | 100000 |
| E002 | Associate | 101000 |
| E003 | Team Lead | 200000 |
| E004 | Team Lead | 50000 |
| E005 | Manager | 120000 |
| E006 | Manager | 110000 |
| E007 | Associate | 50000 |
| E008 | Associate | 80000 |
| E009 | Associate | 90000 |
| E010 | Associate | 50000 |
| E011 | Team Lead | 90000 |
| E012 | Associate | 100000 |
| E013 | Manager | 90000 |
Now select Salary column, Go to Home -> Conditional Formatting -> Colour Scales -> More Rules -> Format Only Cell that contain
Set condition as below
Salary more than 100000 will be converted into red.
The concept can be applied more complex scenarios.
