Hari,

I don't think so. Precendent cells can only be found through a manual
procedure or through the use of VBA procedures, not through formulas.

HTH,
Bernie
MS Excel MVP

Hi Bernie,

Hi,

Cant conditional formatting be used here?

Thanks a lot,
Hari
India