Forum Discussion

Karen Heinrich's avatar
Karen Heinrich
Copper Contributor
Mar 07, 2018

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 ...
Formulas & Functions
Need Help
Willy Lau's avatar
Willy Lau
Iron Contributor
Mar 08, 2018

Yes, I know.  I mean your second formula does not handle a case that the first occurance is former to the current column but with a latter row ( sorry for my poor English).

 

 

Jamil's avatar
Jamil
Bronze Contributor
Mar 08, 2018

it is ok. I am not native English either :)

 

Thanks for clarifying.

 

Re: "In your file, try to change F22 and G21 to Tony"

 

that was just a reference error. I fixed it in the attached file.

 

 

 

  • Willy Lau's avatar
    Willy Lau
    Iron Contributor
    Mar 08, 2018

    Yes.  It is the reference problem.  I just elaborated how I concluded that your answer is the same as Haytham's.  

    • Jamil's avatar
      Jamil
      Bronze Contributor
      Mar 08, 2018
      so, if i understood correctly ;-) you are saying now my answer was not the same as Haytham's? right?

Resources