Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.
If you want to find numbers that are above or below average, you don’t have to calculate that average and then review the values for those higher or lower. With conditional formatting in Excel, you can automatically highlight those numbers.
How to Highlight Top- or Bottom-Ranked Values in Microsoft Excel howtogeek.com - get the latest breaking news, showbiz & celebrity photos, sport news & rumours, viral videos and top stories from howtogeek.com Daily Mail and Mail on Sunday newspapers.