Excel 2007....I have two worksheets where I need to detect a particular cell
background color in one of the worksheets and duplicate in another (not the
same formated sheet). I need to do this in a VBA Macro. I hope this is
enough information.....