Help me!

[gledister]

I have this problem...

Imagine we have this columns
<TABLE style="WIDTH: 96pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=128><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #f0f0f0; WIDTH: 48pt; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #f0f0f0; BORDER-LEFT-COLOR: #f0f0f0" height=20 width=64 align=right>1</TD><TD style="BORDER-BOTTOM-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-RIGHT-COLOR: #f0f0f0; BORDER-LEFT-COLOR: #f0f0f0" width=64 align=right>1</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #f0f0f0; BORDER-LEFT-COLOR: #f0f0f0" height=20 align=right>0</TD><TD style="BORDER-BOTTOM-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #f0f0f0; BORDER-RIGHT-COLOR: #f0f0f0; BORDER-LEFT-COLOR: #f0f0f0" align=right>0</TD></TR></TBODY></TABLE>

And we are going to do this simple action 1-1=0 and 0-0=0.
My question is:
Is there any possibility to highlight the solution of the zeros that comes from only this operation 0-0 and all the other zeros which come from whole the other operations we dont want to highlight them.

Thanks in advance.

 

[number kruncher]

You could use Conditional Formating e.g.

=AND(A1=0,B1=0)

Format as required...

 

[cjcobra]

I'd put another column next to it with =if(and(a1=0, a2=0),1,"") and use a conditional format to highlight anything with a 1. You may be able to put this directly into the conditional format, but this would be easy.

 

[gledister]

explain me better...
I dont want that when operation comes to 0 from an operation for example 2-2 get highlighted...