Hi All,

Is there a way that we can use conditional formating to highlight wrong
entries in a SuDoKu?

thanks

Try something like:

IsFormula
=AND(COUNTIF($A$1:$A$9,A3)<1,A1<"")


Mangesh



"Soniya" wrote in message
oups.com...
Hi All,

Is there a way that we can use conditional formating to highlight wrong
entries in a SuDoKu?

thanks

This formating will take only the first square of nine, but when the
sudoku is of 9x9 how ? it should look both vertival and horizontal as
well as 3x3??

My only idea was to give a hint.

Select A1:I1, and

Use

=AND(COUNTIF(A$1:A$9,A1)<1,A1<"")

and

=AND(COUNTIF($A1:$I1,A1)<1,A1<"")

copy down...


Mangesh




"Soniya" wrote in message
oups.com...
This formating will take only the first square of nine, but when the
sudoku is of 9x9 how ? it should look both vertival and horizontal as
well as 3x3??

I will look only one side, since when u add the second conditional
formatting the first one will be discarded since both condition apply
for the same cells.??

Thanks for your help

Hi Soniya,
I am also intrested in the SuDoKu in Excel. Would you mind sharing the
same once completed?

Regards,

Soniya wrote:
I will look only one side, since when u add the second conditional
formatting the first one will be discarded since both condition apply
for the same cells.??

Thanks for your help

get it from here....
http://www.andypope.info/fun/sudoku.htm

Thank you Soniya.
Regards,

Soniya wrote:
get it from here....
http://www.andypope.info/fun/sudoku.htm

Hi Soniya,

I had tried the above solution which I suggested. You need to add both the
conditions (enter first. click ADD and then enter second)

Mangesh



"Soniya" wrote in message
oups.com...
I will look only one side, since when u add the second conditional
formatting the first one will be discarded since both condition apply
for the same cells.??

Thanks for your help

Effective and simple - just brilliant.

Thanks, Chris