Use conditional formatting to format cells based on the cell’s value.
To Add Conditional Formatting:
- Select a range of cells to which you want to apply conditional formatting.
- HOME >> Styles group >> Conditional Formatting
- Type a value and format then click OK
Highlight Cell Rules:
Use this to highlight all cells greater than a certain value, less than a certain value, all values that contain a certain element, etc.
HOME >> Styles group >> Conditional Formatting >> Highlight Cell Rules >> Greater Than
Top/Bottom Rules:
Use this to highlight the top 10 cells, cells in the top 10 percent, cells above average, etc.
HOME >> Styles group >> Conditional Formatting >> Top/Bottom Rules >> Top 10 items
Data Bars:
Use this to insert a horizontal bar (similar to a Bar chart) in each cell to visually represent the value of that cell, relative to all the other cells
HOME >> Styles group >> Conditional Formatting >> Data Bars
Master Microsoft Office
Office is the industry standard for desktop publishing. It offers a full suite of productivity tools and is always adding new features.
We offer the best Microsoft Office training in NYC. Keep up to date and learn how to create engaging presentations, generate reports on the fly, automate tasks, and more! Our expert instructors guide students of all levels through step-by-step projects with real-world applications. Sign up individually, or contact us about corporate training today: