Is it possible to use format painter in conditional formatting?
I have columns of data that I would like to alternate between light and dark red to match the previous columns given that the row 10 contains text.
I have attached my excel file. The area in question is highlighted in green in the "Daily Reports" worksheet. Basically I have a variable sized range and I want the formatting to "grow" as the range increases in size. But it has to match the column two to it's right.
Thanks again.
Bookmarks