Conditional Formatting explained using the CRaFT methodology.
When to use
Conditional Formatting can assist in building a financial model in Excel which is easy to understand and navigate through.
- Conditional Formatting is a feature that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a corresponding formula
- Accessed from the ‘Home’ tab (or ALT + O + D), conditional formatting formats the cell(s) selected depending upon whether a condition is TRUE
- Conditional formatting is now much more flexible:
- More conditions allowed
- Conditions do not have to be mutually exclusive
- Facilitates traffic light reporting, etc.
Lesson notes are only available for subscribers.