Highlight rows based on content of cell

[JFW1961]

Hi,

I have a spreadsheet with 12,888 rows.
In column R of each row the cell value equals either "Duplicates" or "No Duplicates".
I would like to be able to highlight a row (and the row immediate below) if the cell in column R = "Duplicates".

Can somebody tell me how to do this?

Thank you.

 

[Geoff H]

Could be done with conditional formatting.
What have you got in col R for "the row below"?
G.