Forum Discussion
Highlight First Occurrence across mutliple colmuns and rows.
I am having trouble getting my conditional formatting to work. I am trying to highlight the first occurrence of value in a range of D19:I137. I tried condition formatting duplicate value and it ...
Hi Karen,
Please try this formula,
=COUNTIF($D$19:D137,D19)=1
But make sure to select the whole range D19:I137 so that the cell D19 is the active cell before you apply this formula in the Conditional Formatting.
Your answer highlight the 3rd row Tom.