A1 (will be highlighted as per condition). if A1 highlighted, the the entire row (B1,C1,D1......)should be highlighted with color of A1...
Next Row
A2 (will be highlighted as per condition). if A2 highlighted, the the entire row (B2,C2,D2......)should be highlighted with color of A2...
LIKE...