Conditional formatting changes how a cell looks when its value meets a rule. It lets you spot late deliveries, low stock or a sales dip without reading every row.
Three rules to start with
- Highlight cells greater than a value: for example, orders above 10,000 rupees.
- Colour scales: shade a column from low to high, so trends show at a glance.
- Formula rules: for example, highlight a row when the due date has passed.
A caution
Too many colours hide the message. Use one colour for the problem you want people to act on, and keep the rest plain.
Once the data is clean, read data validation in Excel and the formulas every analyst should know. Book a free demo class, and ask a counsellor for the current course schedule.
