Conditionally formatting large table

**davidman1** · 10-24-2012, 07:31 PM

Hi

I want to put some conditional formatting onto a (large) table to go from each cell in Sheet1 to its matching cell in Sheet2 - is it possible to do that or copy relative references within conditional formatting?

Thanks
David

**Pete_UK** · 10-24-2012, 08:16 PM

Yes, you can use relative references, and you can use the Format Painter icon to copy the (conditional) formatting from one group of cells to another.

Hope this helps.

Pete