MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pattern checking


Posted by Lisa on September 09, 2001 6:39 PM

Hi

Can anyone remind me what the excel function is that checks a block of text for patterns in the formula. It highlights any cells where the formula is different to the other cells in the block. Just can't remember how to do it.

Thanks.


Posted by Tom Urtis on September 09, 2001 7:22 PM

Lisa, what I think you are looking for is a conditional format formula that gives a checkerboard effect. If so, the formula is:

=MOD(ROW(),2)=MOD(COLUMN(),2)

Tom Urtis