Conditional formatting in Excel is a very useful tool for analysing data and made it easy to give a special format to a group of cells based on value of another cell. Among the uses that can provide you is the power to apply a specific font or different fill colour to those cells that meet user-specified rules and thus facilitate their visual identification. Here I present a series of entries for better understanding of the tool.
1. Conditional Formatting - what it is and how to apply
2. Highlighting cells using conditional formatting
3. Formulas for selecting cells
4. Conditional Formatting - Data Bars (coming soon)
5. Conditional Formatting - Color Scales (coming soon)
6. Conditional Formatting - Icon Sets (coming soon)
7- Advanced techniques 1 (coming soon)
8- Advanced techniques 2 (coming soon)
No comments:
Post a Comment