How to Find a Specific First Number in a Row
"Herbert Seidenberg" wrote:
Assuming your data at A1 looks like this:
0 0 1 2 3 4
0 0 1 2 3
0 0 1 2
1 0 1
then this Conditional Format will highlight
only the first zero in the third row:
Enter this Conditional Format at B1 and
Copy Paste Special Format to all:
=ISNUMBER(B1)*(B1=0)*(SUM($A1:A1)=0)*(COUNTA($A1:A 1)=0)
I can't get this to work. Because of other material in the beginning columns
and the first row I use
=ISNUMBER(P2)*(P2=0)*(SUM($O2:O2)=0)*(COUNTA($O2:O 2)=0)
in N2. If entered into P2 there is a circular reference error.
Do I select the area I want to analyze and then Paste Special Formats,
which doesn't work.
|