software

All right, I had some time on my hands on a recent business trip, and I
stumbled accross this numeric puzzle called a Sudoku. I found it in the USA
Today. It was the first time I had seen it, but it's probably well known to
everyone else.

So, I started working the puzzle, and decided that Excel could do most of
the work for me. So I created some fairly complicated formulas (combinations
of nested IF's and OFFSETS) to do the process of elimination for me. The
formulas work great. Then I use conditional formatting to highlight the
cells that have been eliminated. Again, works great.

Now the part I'm stumpped on.

I used conditional formatting, to hightlight the numbers that could be
eliminated (i.e., deleted). So, as you solve one square, conditional
formatting then highlights everwhere else in the puzzle that can not be that
number. I happend to pick the color lavender. However, it becomes very
tedious to go cell by cell and delete the cells that are lavender.

What I would like to do is, run a macro that looks at the result of the
conditional formatting, and selects all the cells that are lavender.

Note: The formula I used in the conditional formatting changes from cell to
cell. So using the advanced features of FIND, do not work correctly. Not to
mention that the exterior cells have borders, while the interrior cells do
not.

Ideas?

Take a look at www.xldynamic.com/source/xld.CFConditions.html

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Jonathan Cooperquot; gt; wrote in
message ...
gt; All right, I had some time on my hands on a recent business trip, and I
gt; stumbled accross this numeric puzzle called a Sudoku. I found it in the
USA
gt; Today. It was the first time I had seen it, but it's probably well known
to
gt; everyone else.
gt;
gt; So, I started working the puzzle, and decided that Excel could do most of
gt; the work for me. So I created some fairly complicated formulas
(combinations
gt; of nested IF's and OFFSETS) to do the process of elimination for me. The
gt; formulas work great. Then I use conditional formatting to highlight the
gt; cells that have been eliminated. Again, works great.
gt;
gt; Now the part I'm stumpped on.
gt;
gt; I used conditional formatting, to hightlight the numbers that could be
gt; eliminated (i.e., deleted). So, as you solve one square, conditional
gt; formatting then highlights everwhere else in the puzzle that can not be
that
gt; number. I happend to pick the color lavender. However, it becomes very
gt; tedious to go cell by cell and delete the cells that are lavender.
gt;
gt; What I would like to do is, run a macro that looks at the result of the
gt; conditional formatting, and selects all the cells that are lavender.
gt;
gt; Note: The formula I used in the conditional formatting changes from cell
to
gt; cell. So using the advanced features of FIND, do not work correctly. Not
to
gt; mention that the exterior cells have borders, while the interrior cells do
gt; not.
gt;
gt; Ideas?
Hi Jonathan,

Yeah, Sudoku is all the rage now days. My local paper started running it
daily and I too decided to let Excel 'do the heavy lifting'.

Just from an interest standpoint, I used a number of named ranges and code
to a find and delete. After entering the clue numbers, hit a button and
all empty cells have 1 - 9 entered. Select a given clue number and hit a
SIFT button and it eliminates that number in the horzional, vertical and the
9 x 9. Select the next clue and so on. Also have an Auto-Sift which will
run from top left to bottom right and do the eliminations.

Will solve the easy and some medium but does not have the deductive
reasoning capability to do the Hard and Evil puzzles.

I don't have any solution to offer on you post, just ramblin.

Regards,
Howard

quot;Jonathan Cooperquot; gt; wrote in
message ...
gt; All right, I had some time on my hands on a recent business trip, and I
gt; stumbled accross this numeric puzzle called a Sudoku. I found it in the
gt; USA
gt; Today. It was the first time I had seen it, but it's probably well known
gt; to
gt; everyone else.
gt;
gt; So, I started working the puzzle, and decided that Excel could do most of
gt; the work for me. So I created some fairly complicated formulas
gt; (combinations
gt; of nested IF's and OFFSETS) to do the process of elimination for me. The
gt; formulas work great. Then I use conditional formatting to highlight the
gt; cells that have been eliminated. Again, works great.
gt;
gt; Now the part I'm stumpped on.
gt;
gt; I used conditional formatting, to hightlight the numbers that could be
gt; eliminated (i.e., deleted). So, as you solve one square, conditional
gt; formatting then highlights everwhere else in the puzzle that can not be
gt; that
gt; number. I happend to pick the color lavender. However, it becomes very
gt; tedious to go cell by cell and delete the cells that are lavender.
gt;
gt; What I would like to do is, run a macro that looks at the result of the
gt; conditional formatting, and selects all the cells that are lavender.
gt;
gt; Note: The formula I used in the conditional formatting changes from cell
gt; to
gt; cell. So using the advanced features of FIND, do not work correctly. Not
gt; to
gt; mention that the exterior cells have borders, while the interrior cells do
gt; not.
gt;
gt; Ideas?