I have four different sheets in an Excel 2007 workbook.

I am trying to conditionally format cells from the four different sheets to show the highest number in text with red font.

The problem is when I select the cells in one sheet, press Ctrl, and select the cells in the other sheet when I enter the condition the format only activates on the active or sheet in view and does not take into account the cells selected in the other sheets.

Any ideas or suggestions?
Tks