View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
yelnocer yelnocer is offline
external usenet poster
 
Posts: 1
Default 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