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 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!