Summary
- Conditional formatting in Excel can help data stand out and be easier to understand
- Colour-coding, adding icons and creating rules for formatting are all good ways of doing this
- Using icons can help categorise data and create an intuitive understanding of a report
- Highlighting entire rows can help direct attention to a specific cell
- Alternate row colours (called zebra shading) can also help improve clarity and readability, particularly when looking at large data sets
- This can all be done easily and dynamically, so that formatting updates automatically when changes are made to the document.
By Chifundo Kasiya
Original Article