Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jonathan Cooper
 
Posts: n/a
Default Sudoku

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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Color a single digit in a mult-digit number cell Phyllis Excel Discussion (Misc queries) 6 November 17th 05 12:46 AM


All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"