Conditional Formatting in multiple column [Closed]


I have done conditional formatting in column D (if duplicate value found then cell color will be red), now I want the respective row cell to be colored as well. For example if column D, row 4 is red then A4 and C4 should be red. Kindly help me ASAP.


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!