I have 2 worksheets that I am merging into a single worksheet and am using
cells from one or the other worksheet based on conditions that I am checking.
In some cases the cell I want to copy have a different color text or
background and if I use that cells contents I also want to use the color but
it won't be used in all cases. How do I selectively format the cell color as
needed?