- Mar 23, 2006
I have text and number values in random order in column A. In column E I have same values in A but in different order. I have to manually type both of these values. I want to format cells in column E so that if I type any values other than A, the cell should fill with red and if any value duplicates in either column A or E then the duplicated cells should fill with yellow. Any suggestions.