...change the colour of the 4th row based? I have three rows in excel.2 of them are red and one green .I want to change the colour of the 4th row based on the first 3 rows ,if 2 rows are rows are red the colour of the 4th row should be red,if two rows are green then the colour of the fourth row should be green