Forum Discussion

Copper Contributor

Nov 23, 2022

Solved

Format cells based ONLY on value of adjacent cells

Hi - every help article I've found gives good directions for how to format cells based on a comparison of current cell value to adjacent cell value (i.e. equal or unequal, greater than or less than),...

excel

Patrick2788
Nov 23, 2022
ejhdrobny
Here's what the rules look like (Sample xlsx attached, too):

Conditional Formatting 11.23.xlsx16 KB

Patrick2788

Silver Contributor

Nov 23, 2022

ejhdrobny

Here's what the rules look like (Sample xlsx attached, too):

Conditional Formatting 11.23.xlsx16 KB

ejhdrobny
Copper Contributor
Nov 23, 2022
Thank you! I had tried this approach applying the rule to the entire column and nothing was happening, but when I followed your example and specified a cell range within that column it did work.
- Patrick2788
  Silver Contributor
  Nov 23, 2022
  You're welcome. Glad it worked!