Excel currently does not have the ability to conditionally format from a
function. When writing complex formulas regarding a range of data, it would
be nice to highlight cells as they are conditionally being selected by a
formula. This would be very helpful to validate formula accuracy and for
error checking. The conditional formatting tool is a step in the right
direction, but cannot be imbedded into a questionable formula. A simple
FORMAT (target, text color, background color) would do wonders.

----------------
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...et.f unctions