Hii..

Can any one please help with conditional formatting based on adjacent 3 columns ???

Eg

if any of Cells in column A1 B1 C1 is filled red then Cell D1 must turn red.
if any of Cells in column A1 B1 C1 is not filled red & is filled yellow then Cell D1 must turn yellow.
if any of Cells in column A1 B1 C1 is not filled red nor filled yellow then Cell D1 must turn green.

Please HELP !!!

THANKS