[RESOLVED] conditional formatting in excel 2007

[merhaba]

Hi there,

Please help me with the following excel problem..
say I have 50 rows of lottory numbers (tickets)
and there is this last draw of lottary nums.
2-10-27-30-32-54

I want to highlight all matching numbers in a say blue color..
I tried some formulas but it did not work for me ?
countif(....)
please have a look at the attached file and send me a working one.

thanks.

[NickThissen]

This is not so hard I think... I just tried it out and I never used conditional formatting before.


I got it to work doing one column at a time:

Take the first column. Select all your values in the first column (except the '2' in the "header" part ofcourse). Click the 'Conditional Formatting' dropdownbutton in the ribbon and choose 'Highlight Cells Rules'. Then choose 'Equal To...'.
In the popup window click the button to the right of the textbox where you have to enter the value. Now click the "header" '2' cell (it will get a dashed line) and press Enter, and then click OK.

Repeat for every column.

[merhaba]

Thanks
yes it is one way but I need a formula to manage it..because number "2" is not only in coloum 1,it can be in any coloumn too...

thanks

oh YES ı DİD İT....
HERE İS THE FORMULA
=EĞERSAY($B$3:$G$3;B6)...THİS İS TURKISH WAY..ı NEED TO USE ";" INSTEAD OF ","
=COUNTIF($B$3:$G$3,B6)..THIS IS ENGLISH WAY...

[NickThissen]

I don't understand..?

Surely you want to color all the 2's in the first column, and all the 10's in the second column, all the 27's in the third column, etc...? Or am I not understanding your question?

[merhaba]

Look at the attached file you will understand what I mean..

thanks

[merhaba]

hi there,
I use excel-2007 and I want to know if
Is there any way to display the SUM of the highlighted items in a row?

[assis]

Here´s a possible solution.