conditional formatting Archives

How To Highlight the Highest or Lowest Value in Google Sheets (Easy Guide)

March 3, 2026January 29, 2021 Sumit Bansal

Highest and lowest cells highlighted in google sheets

Use Conditional Formatting in Google Sheets to automatically highlight the highest or lowest value in any dataset with no manual scanning required. This tutorial covers max, min, top N, bottom N, and full-row highlighting with simple custom formulas.

A Simple Google Sheets Compare Two Columns Guide for 2026

January 5, 2026September 4, 2020 Sumit Bansal

To compare two columns in Google Sheets, use conditional formatting and the COUNTIF function. This guide shows how to compare exact row matches and full columns that contain unsorted data. Comparing Columns for Matching Data When working with large amounts of data, the human eye is not very capable of identifying small differences or similarities … Read more