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

[martabn]

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 now want the Attendance column to say "Yes" if in the Name column the value is highlighted.

I have attached a picture of a sample sheet.

Is there a way to do this, would it have to be with a different method completely other than conditional formatting? 

Thanks!

[#2 · Accepted solution]

@martabn

In B2:

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

Fill down.

[#3]

Hi Hans,

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