Excel Chessboard problem, boarders and cell shading

[voyage2000UK]

I made an Excel chessboard. I play chess on it though email and send
the excel sheet as an attachment. Moves are made by cut and pasting
the cells. It works good except for two things. One, I always have to
go back and check the boarders of the cell that was cut. The boarders
don't always stay intact. Two, the chessboard has both white and gray
squares. When I cut and paste from a gray to a white square, the color
follows. Any help out there?

Basically, I need to save the board as a template. Unfortunately, the
template changes when a move is made. How do I make a template that
doesn't change when I cut and paste in new data?

Thanks, John

 

[Miguel Zapico]

You can do it in two steps:
- Copy and paste values.
- Delete the original cell.
This way the format will remain unaltered.

Hope this helps,
Miguel.

 

[voyage2000UK]

Thanks Miguel. You are right, copy and paste is better then cut and
paste. That solves the boarder problem. Unfortunately, the cell
colors still change. It's not a big deal to change the color. I was
just hoping there was a way to tune up the spread sheet so that it is
easier and faster to make the moves. Talk to you later, John

 

[Kevin Vaughn]

Perhaps you can use conditional formatting. First set the background of the
cells to one of the colors and use 2 conditional formatting formulas for the
other background color. The formulas I came up with are:

=AND(MOD(ROW(A1),2) = 1,MOD(COLUMN(A1),2) = 1)
=AND(MOD(ROW(A1),2) = 0,MOD(COLUMN(A1),2) = 0)

 

[MartinW]

Hi John,

How about just making your chess pieces image files floating over your
grid then you can just click and drag them where you want.

Of course considering the fact that you are emailing the worksheeet you
might need to do a bit of fiddling with object linking and embedding
to get something that works smoothly.

Another option is to lodge your worksheet on a freebie website that only
you and your competitor have access to.

Just a couple of random thoughts.
Martin

 

[Miguel Zapico]

You can use "paste values" (edit ->paste special->values) instead of paste.
That should solve also the color issue.

Miguel.

 

[voyage2000UK]

Thanks all, but of the above, none works. I don't know how to do it.
Perhaps there isn't a way to do it with Excel. The web idea is good,
but I work on a ship. I can only get email. Besides, there are chess
boards on the net already. If any want me to send the board... Oh
well, never mind.
1 2 3 4 5 6 7 8
a a
b b
c c
d d
e e
f f
g g
h h
1 2 3 4 5 6 7 8


1 31 61 91
2 32 62 92
3 33 63 93
4 34 64 94
5 35 65 95
6 36 66 96
7 37 67 97
8 38 68 98
9 39 69 99
10 40 70 100
11 41 71 101
12 42 72 102
13 43 73 103
14 44 74 104
15 45 75 105
16 46 76 106
17 47 77 107
18 48 78 108
19 49 79 109
20 50 80 110
21 51 81 111
22 52 82 112
23 53 83 113
24 54 84 114
25 55 85 115
26 56 86 116
27 57 87 117
28 58 88 118
29 59 89 119
30 60 90 120