Introduction
Formula-based rules let you change how cells look based on their values or other cells. This helps you spot important data quickly without checking each cell one by one.
When you want to highlight sales numbers above a target automatically.
When you need to mark overdue dates in a list of tasks.
When you want to color code expenses that are higher than average.
When you want to show which students scored below passing grade in a test.
When you want to flag duplicate entries in a list.