Conditional Formatting Excel 2007

  • Thread starter Thread starter yelnocer
  • Start date Start date
Y

yelnocer

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?
 
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 tab>Styles>Conditional Formatting>New rule>Use a formula....
Enter this formula in the little box:

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

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