Conditionally formatting large table

[davidman1]

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]

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

[davidman1]

That's great - thanks. Wasn't too keen on the idea of filling in a 15x24 table with two conditions each.