Highlight wrong entries in SuDoKu

[Soniya]

Hi All,

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

thanks

 

[Mangesh Yadav]

Try something like:

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


Mangesh

 

[Soniya]

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??

 

[Mangesh Yadav]

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]

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

 

[vb6google]

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

Regards,

 

[Soniya]

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

 

[vb6google]

Thank you Soniya.
Regards,

 

[Mangesh Yadav]

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

 

[cjakeman]

Effective and simple - just brilliant.

Thanks, Chris