Excel formatting should expand to other cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Is this what you mean?

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

Regards
Rowan
 
Back
Top