Conditional Formatting Cells In Diff Sheets

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

Tks for your quick reply.
I have named the cells on the other sheets.
When I try to CF I do not find anywhere to select the names to apply the rule to

NBVC, tks for your replies.
I have literally been trying to make this thing work for over four hours and I'm definitely doing something wrong or overlooking some basic information. I'm not going to give up.

I have three sheets in a work book.
I want to simply have the highest value within Row # 3 in those three sheets highlighted in red on whichever sheet it might occur.

I named the cell ranges in each sheet and then tried to enter them into the CF formula but it won't stay and always only formats the active sheet.

Is this where I am supposed to enter the named cell ranges?

Conditional Formatting Rules Manager
Rule... Applies To: sheet1,sheet2,sheet3
Tks
Russell

I've attached a very small version of what I am trying.
I need for the highest value in the Sales rows in the three different sheets to be highlighted in red.

Tks