Is this what you mean?

Select cell B2. FormatConditional FormattingFormulaIs =A24. Set the
required formatting.

Regards
Rowan

Pariah wrote:
Excel should have the ability to expand it's conditional formatting to other
cells. For instance, if cell A is = 4, then cell B should have "this"
formatting. Possible? Not yet. I would think in the universe of conditional
formatting, this would be next.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming