Hi,

I have a workbook with multiple worksheets (continually adding) and I would like a macro that:

For every worksheet in the workbook except for worksheets named "Main" and "Full Detail" to format each cell from cell B3 (Cell B3 compares to Cell B2, but B2 doesnt compare to B1 as B1 is a title) to the last used column and last used row IF the cell above is different.

The macro always needs to ignore the data in columns A and B.

Example (starting at cell B3 which would compare to Cell B2):


xxxxx xxxxxx xxxxxx xxxxxx xxxxx xxxx
xxxxx xxxxxx xxxxxx bbbbb xxxxx aaaa
xxxxx xxxxxx xxxxxx bbbbb xxxxx aaaa
xxxxx xxxxxx xxxxxx bbbbb xxxxx aaaa
xxxxx cccccc xxxxxx bbbbb xxxxx dddd

So in this instance the cell with the "bbbbb" and "aaaa" in the 2nd row and the cells with "cccccc" and "dddd" in row 5 would be formatted red. This macro would continue until all worksheets are checked (except for Main and Full Detail).

I've been able to achieve this manually with conditional formatting and even using macro recorder and format painter, but it causes some problems with other cells as it changes things like date and money formats.

Help would be much appreciated. I'm definitely learning lots from what started out as a simple "project"!

Thank you all.

Dave.