Give this Conditional Formatting formula a try...

=(COUNTIF(D:D,A2)+COUNTIF(H:H,A2)+COUNTIF(L:L,A2)) 0

--
Rick (MVP - Excel)


"Kashyap" wrote in message
...
Hi, I was trying to apply conditional format for A2. That is if the value
of
A2 repeats in either Column D or Column H or Column L, A2 should be
highlighted.