Conditional Formatting Excel 2007
 

Just installed 2007 and like it - would like to use conditional
formatting to highlight cells based on if the cells equal a group of
numbers - actually it is a worksheet containg all the office pool
powerball tickets so I want to go through the worksheet and highlight
the winning numbers - so I need to be able to have something that says
if a cell in the range = 1 or 2 or 3 or 4 or 5 etc. Can it be done?




--
yelnocer

Conditional Formatting Excel 2007
 

Try this...

Assume the numbers that are drawn are entered in the range A1:E1

Your pool numbers are in the range A3:E10

Select the range A3:E10
Goto Home tabStylesConditional FormattingNew ruleUse a formula....
Enter this formula in the little box:

=AND(COUNT(A3),A30,OR(A3=$A$1:$E$1))

Click the Format button
Select the desired style(s)
OK out


--
Biff
Microsoft Excel MVP


"yelnocer" wrote in message
...

Just installed 2007 and like it - would like to use conditional
formatting to highlight cells based on if the cells equal a group of
numbers - actually it is a worksheet containg all the office pool
powerball tickets so I want to go through the worksheet and highlight
the winning numbers - so I need to be able to have something that says
if a cell in the range = 1 or 2 or 3 or 4 or 5 etc. Can it be done?




--
yelnocer