[RESOLVED] conditional formatting in excel

[merhaba]

hi, I have an excel page as seen in the attachment below.
What I need is to write a formule so that it can display the number of the formatted cells in each row...I did it manually but the page is not that small..I have 3000 rows on my excel page

thanks for any help in advance..

[opus]

-1- This is a question for the Office Development forum, not for the Math Forum!

[opus]

-2- Why don't you use the EXCEL command "countif" (I hoe that's the correct englisch name for the german "ZählenWenn"), as the criteria yo should use the same as in the conditional format.

[merhaba]

Hi,
I know that function but not sure how to write the whole statement..
=COUNTIF(........????)..if the Selection Range(A1:J25) is coloured in red THEN
counter=counter+1...
....
so will you please help me for what im tring to achive..?

Thanks

[opus]

for cell M1

=COUNTIF("A1:J1";your formatting condition here!)

copy/paste this code for al cells below!

[Rassis]

See the attached Excel spreadsheet. Random numbers between 10 and 100 are input in cells B5 to G28. Cell I5 down to cell I28 yield the number of formatted cells in each row. They all match the same condition, that is, in this particular example, to be between 10 and 20. Of course you can change these values or change the condition.

Hope it helps but, please, next time use any Excel forum; this for instance: http://www.ozgrid.com/forum/

[merhaba]

Thanks Rassis..
you did a great job...It took me days to solve the problem.. finally I gave up conditional formatting....and did the same task using a
=SUM(COUNTIF(A1:J1,{8,14,25,37,75....}))

THANKS

[merhaba]

Hi,
Is it possible to format the numbers indicated
in the formule below(8,14,25,37,75...) without using "conditional formatting"
=SUM(COUNTIF(A1:J1,{8,14,25,37,75....}))

Thanks.