Color Scale Based News Today : Breaking News, Live Updates & Top Stories | Vimarsana

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.

You can always set up another conditional formatting rule in Google Sheets for one set of cells exactly the same as another. But why do the extra work? Here are a few ways you can copy your conditional formatting.