Bob,
I didn't explain it well, sorry. What if you have a large spreadsheet and some of the cells are highlighted. I want to highlight the current row without losing any previous highlighted cells. I did try both of the option you suggested and it didn't work for me. I have attached a sample file - Test.xls that shows you what I mean. I really do appreciate the help. Dee1
|