Forum Discussion

martabn's avatar
martabn
Copper Contributor
May 12, 2023
Solved

Text fill a cell based on the colour fill of another cell

Hello,   I'm trying to make an automatic attendance tracker based on pasted reports. So far I have set up conditional formatting to flag duplicate values (names) which is working fine. However I n...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    May 12, 2023

    martabn

    In B2:

     

    =IF(ISNUMBER(MATCH(A2, $G$2:$G$100, 0)), "Yes", "")

     

    Fill down.

HansVogelaar's avatar
HansVogelaar
MVP
May 12, 2023

martabn

In B2:

 

=IF(ISNUMBER(MATCH(A2, $G$2:$G$100, 0)), "Yes", "")

 

Fill down.

  • martabn's avatar
    martabn
    Copper Contributor
    May 12, 2023
    Hi Hans,

    Thank you so much! I was overcomplicating it way too much!

Resources