what i would like is to put a conditional format in say a22 and have excel
look along 22 row and check each of 7 columns for a red cell and if it finds
one make a22 a red cell

please help