I have a column which looks like this -

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?

CodePudding user response：

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

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