remain cell counting

[9khonnei]

I want to automatic count the "background color" after my table is " True " criteria condition each cell in the table will change from white color to gray color if not true the background no change than countting.(see pict.)

10713032.gif

my formula criteria Format condition already is "TRUE"
(CF : formula is =COUNTIF(array,cell)>1 ,font color=gray, pattern color =gray.)
and some of cell aready automatic change the backgroud color to "Gray color".
accept condition of my sheet.

becuase if my table not TRUE the my table count cell = 100 cell
than if each cell is TRUE my table will remain or balance counting between white color with gray color to show total remain how many cell.
In my picture show for exsample remain = 19 cell from total 100 cell is mean " TRUE " total 81 cell.

BSG.

[martindwilson]

just use the same criteria in a formula
=COUNTIF(A1:D10,">="&0)
or
=COUNTIF(A1:D10,">="&1)
depending on whether or not uou want to count 0

[9khonnei]

thank for answer
But can't counting correct on you formula alway show = 90
becuase my table is Fix show 100 cell and i'm fix the number in table also.

I use critiria for compair data with other sheet if match number than Condition Format with action hidden number by use
CF : font & background setting to " Gray color "
If some cell not match data.The font&background not be change.
than counting remain cell how many cell not match or How many cell match.

[martindwilson]

post a work book with example

[9khonnei]

ok i make sample file for you help.
sample.xls
thank you in advance

[DonkeyOte]

Based on your sample file it appears that grey cells are determined by the fact that the numbers in the cells appear in your 2nd table, in which case isn't the count of grey cells simply the count of numbers in the 2nd table ?

Please Login or Register  to view this content.

or if you need to check for duplicity of numbers (ie entering 84 twice in that 2nd table)

Please Login or Register  to view this content.

[9khonnei]

Thanks DonKeyOte
is WORK

[9khonnei]

Thank you every one
and "DonkeyOte"



BSG.

[DonkeyOte]

This is a different question so please ask in an entirely new thread.