NEWBIE needs help

  • Thread starter Thread starter Robert McAnally
  • Start date Start date
R

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
 
Hi
and there're really some matches. e.g. lets say cell B3 should match
with B6
what does the formula
=B3=B6
return?
 
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?
 
Back
Top