I need help finding a way to highlight rows while doing a conditional format for the unique values of a column. For example if column had the values
1
1
2
3
3
I would want the entire row 3 highlighted. Also if anyone knows a way to write a macro do the conditional format across workbooks that would be of great help so I don't have to paste over the values that I am comparing.
1
1
2
3
3
I would want the entire row 3 highlighted. Also if anyone knows a way to write a macro do the conditional format across workbooks that would be of great help so I don't have to paste over the values that I am comparing.