I am using the vlookup function to look at 2 seperate worksheets and take
values from the cells of one or the other worksheet based on the results of
the vlookup and merging the information on a 3rd worksheet. The 3rd
worksheet has a job id which is the lookup value and based on that id, cells
are selected from one of the original worksheets. Some of the original
worksheet cells are formatted a different color (red), but when they are
moved to the 3rd (merged) worksheet they are black (the default color). I
looked at using conditional formatting but don't know how to get it to work
since the result is based on the vlookup function. What I want to do is get
the cells that are red on the original worksheet to be red on the new merged
worksheet. Is there any way to do that as part of the update without having
to manually change the color?