FG
💻 Software

Highlight a row where a value changes relative to previous row (Conditional Formatting?)

Fresh5 days ago
Mar 15, 202624484 views
Confidence Score0%
0%

Problem

I have a spreadsheet with lots of data. The data is grouped so that all the rows with a certain value in one column (say C) are grouped together. I want to highlight the "boundaries" - i.e., the first row where the value in column C is different from its immediate predecessor. For example: In this …

Error Output

A       B      C
1 Type   Val    Category
2 Cat    1.77     1
3 Newt   1.937    1
4 Toad   1.03     3
5 Newt   0.78     3
6 Dog    0.78     3
7 Worm …

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Highlight a row where a value changes relative to previous row (Conditional Formatting?)

Low Risk

What you suggest should work in combination with the right "applies to" range. For example if your data is in (with headers in ) then : select the range without headers, i.e. use that formula (with preceding =), i.e. =$C1<>$C2 apply required format …

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment