software

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 quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...et.f unctions

After having read your message three times I still have no idea what you're
aiming at

--
Kind regards,

Niek Otten

quot;Barrett at Tyndalequot; gt; wrote in
message ...
gt; Excel currently does not have the ability to conditionally format from a
gt; function. When writing complex formulas regarding a range of data, it
gt; would
gt; be nice to highlight cells as they are conditionally being selected by a
gt; formula. This would be very helpful to validate formula accuracy and for
gt; error checking. The conditional formatting tool is a step in the right
gt; direction, but cannot be imbedded into a questionable formula. A simple
gt; FORMAT (target, text color, background color) would do wonders.
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...et.f unctions
I think what you are trying to do can be done with the quot;Formula Auditingquot;
toolbar. If you are trying to find/higlight the contributors (quot;precedentsquot;)
to a formula, or cells it is used by (quot;dependantsquot;) this can be done using
the above toolbar.

If you're not already aware of this tool bar, right click on any toolbar/the
toolbar area, and tick quot;Formula Auditingquot;.. have a play, it's quite useful
but can get messy! Don't panic though, there is a quot;Remove all arrows buttonquot;
there too.

Regards

quot;Barrett at Tyndalequot; wrote:

gt; Excel currently does not have the ability to conditionally format from a
gt; function. When writing complex formulas regarding a range of data, it would
gt; be nice to highlight cells as they are conditionally being selected by a
gt; formula. This would be very helpful to validate formula accuracy and for
gt; error checking. The conditional formatting tool is a step in the right
gt; direction, but cannot be imbedded into a questionable formula. A simple
gt; FORMAT (target, text color, background color) would do wonders.
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...et.f unctions