In Excel 2007 conditional formatting, you can't refer to cell range addresses on a different sheet.
As a workaround, you can name a range on a different sheet, then use conditional formatting to refer to that named range. This video shows the steps
For written steps, go to my Contextures Blog:
contexturesblo...