I'd be very grateful for some help with an issue I'm having.
I have a sheet, Sheet 1. In it there's a cell displaying a number and a lot of conditonal formatting in place to change the fill colour depending on many different variables.
I also have a Summary Sheet, in which I want the same number and fill colour to display. I have no trouble displaying the number using =Sheet 1!J30 but it's when I try to copy the conditional formatting from the cell that I run into problems. What changes do I need to make to the conditional formatting formula to display it in the Summary Sheet?
Many thanks,
J
Bookmarks