Excel formatting should expand to other cells

[Guest]

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/com...989c6f0&dg=microsoft.public.excel.programming

 

[Rowan Drummond]

Is this what you mean?

Select cell B2. Format>Conditional Formatting>FormulaIs =A2>4. Set the
required formatting.

Regards
Rowan