title: Change a cell to a specific colour in excel if a value comes from a different sheet
body: <p>I have an excel sheet and in one sheet I have the location of different work sites that are worked at and in 5 subsequent sheets I have different jobs to track employee hours. I would like to know if there's any way to change the colour of the cell in the "work site" sheet depending on which "job" sheet the figure came from. I don't want to change the cell colour based on the value but based on which sheet it came from.</p>