0
votes
1answer
1k views

Excel 2007 conditional formatting rule using formula to highlight a row based on matching text between columns

I am checking accountability of whether my office is creating source acknowledgement reports "C", recommended whenever a reference document "A" is read, and required whenever an article "B" is ...
-1
votes
1answer
372 views

Highlighting duplicate column-pair and counting the rows Excel

Given the data below, the column-pair with the same values for at least 4 consecutive rows should be highlighted. Here's an image for better visualization: 2 2 3 4 3 4 3 4 3 4 2 3 1 2 ...
0
votes
3answers
1k views

Highlighting duplicate column-pairs in Excel

Example, this is the data in Excel: 1 2 2 2 3 4 3 4 3 3 2 2 2 2 1 2 The rows which have consecutive duplicate column-pair values (in bold font) should be highlighted: 1 2 2 2 3 4 3 4 3 3 2 2 2 2 1 ...