Copying a grid with mixed attributes (Excel 2003)

H

Howard Brazee

I want to have a grid (a Sudoku puzzle), and fill in some numbers.

I'd like to copy it to another grid (on the same sheet) - the trouble
is, I want the copied numbers to be red - or better yet, protected,
while the empty squares are unprotected and black.

I don't want to select cell by cell changing the color.
 
B

Beth Melton

While conditional formatting may work for some of what you want - the
font color, protecting/unprotecting the cells is another story and I'd
say you'd need to create a macro that will loop through the range and
check the values and protect/unprotect the cell accordingly.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
Top