Dear Sir, I wanted to apply conditional formatting between two sheets If name is available in both sheet then color as shown and if not available then color differently.