Trying to highlight duplicate row-based cells in Google Sheets. What is the most simple formula I could use to do this?
I've tried using VLOOKUP and COUNTIF, but maybe I'm using them incorrectly. Some duplicate cells are being highlighted and some are not. I've cleared formatting after every try.
I've been using:
=countif(F:F,G1)
and
=EQ(VLOOKUP(F1, G:G, 1, FALSE), F1)
If selecting Columns F and G and a CF formula rule of:
=$H1
does not suit then either I have misunderstood or you have Text/Number/space formatting issues so could try:
=text($F1,"#")=text($G1,"#")
instead - if you prefer to leave the formatting as is.
Where the status is binary (either duplicate or not duplicate) just one CF rule may be adequate for both states, since 'standard' fill (of the whole range) may serve instead of another rule.
