Boards
Excel-lentious Question
I'm using conditional formating on a selection of cells, highlighting how a weekly figure compares to a cumulative figure. Each week i want to copy the previous weekly figures one column to the left, in order to maintain visibility of the previous 4 weeks.
My question is, is it possible to copy the colour of the conditionally formatted cell without copying the formatting?
thanksyous