Forum Discussion

Zain_Fazal's avatar
Zain_Fazal
Copper Contributor
Nov 20, 2023

Conditional Formatting for Highlight an entire row based on data in another row

Greetings everyone!   I am currently keeping track of my job applications in an excel sheet. Currently, the table looks something like this:   Company Position Position Number Date Job Pos...
excel
peiyezhu's avatar
peiyezhu
Bronze Contributor
Nov 21, 2023
The Krusty Krab Chef   7/5/2023 some_unique_url.com Bikini Bottom   Applied

only red the second row like above rather than row 4th as below

The Krusty Krab Chef   7/6/2023 some_unique_url.com Bikini Bottom   Rejected
?

what is your expected result?

  • Zain_Fazal's avatar
    Zain_Fazal
    Copper Contributor
    Dec 07, 2023

    peiyezhu 

    So in this case, both rows would be completely red

    • peiyezhu's avatar
      peiyezhu
      Bronze Contributor
      Dec 08, 2023

      Zain_Fazal 

      j2

      =filter(a2:h100,h2:h100="Rejected")

       

      i2

      =iferror(xlookup(e2,n$2:n$100,$n$2:n$100),true)

       

      set condition format formular   =not(

      iferror(xlookup(e2,n$2:n$100,$n$2:n$100)))

       

      I can not set format condition on my side so that I just provide my thoughts.

       

      See the attached for above formulas.

Resources