CODEWITHSUNDEEP
excelexcel-formula
Maxima
Maxima

Reputation: 352

Highlight immediate cells after conditional formatting rule is satisfied

I have a column which looks like this -

Col1
A
B
C
A
D
V
A
X

My first conditional formatting is to highlight all the cells where Col1 contains "A".

But I also want that after all the A cells have been highlighted it should highlight the next immediate cell after A no matter what the value is.

How to go about that?

Edit 01 -

Unable to figure out what am I missing here?

enter image description here

Upvotes: 0

Views: 53

Answers (1)

Spectral Instance
Spectral Instance

Reputation: 2494

The 1st rule below applies conditional formatting if the current cell contains A

Screenshot illustrating proposed solution

and the 2nd applies conditional formatting if the preceding cell contains A.

Upvotes: 2

Related Questions