NEWBIE needs help

[Robert McAnally]

I got this from http://www.contextures.com/xlCondFormat03.html and I have entered the formula as they spell out, but nothing is happening! Why? Please help a newbie that needs help now.

In this example the ticket numbers are in cells B2:G4, and the drawn numbers are entered in cells B6:G6

1.. Select cells B2:G4
2.. Choose Format|Conditional Formatting
3.. From the first dropdown, choose Formula Is
4.. For the formula, use the CountIf function:
=COUNTIF($B$6:$G$6,B2)
5.. Click the Format button.
6.. Select formatting options (green pattern, in this example), click OK
7.. Click OK


Thanks,
Robert

 

[Frank Kabel]

Hi
and there're really some matches. e.g. lets say cell B3 should match
with B6
what does the formula
=B3=B6
return?

 

[Robert McAnally]

I figured it out: needs to be:

=COUNTIF($B$6:$G$6,B2)>0
Hi
and there're really some matches. e.g. lets say cell B3 should match
with B6
what does the formula
=B3=B6
return?