Hi Vladimir,

I am sure it is probably something I am doing wrong, but i cannot get that to work.

I cannot see "New Rule" in the Home ribbon on 365. So i searched for it.
I then get a pop up screen titled "New Formatting Rules"
The only option that i can see that is similar to above is "Use a formula to determine which cells to format"
I put your formula into the box.
I then click format and select red text

All that happens is that all of the names in Sheet 1 are now in red text