"Format" function in Excel

[Barrett at Tyndale]

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/com...dg=microsoft.public.excel.worksheet.functions

 

[Niek Otten]

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

 

[Obi]

I think what you are trying to do can be done with the "Formula Auditing"
toolbar. If you are trying to find/higlight the contributors ("precedents")
to a formula, or cells it is used by ("dependants") 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 "Formula Auditing".. have a play, it's quite useful
but can get messy! Don't panic though, there is a "Remove all arrows button"
there too.

Regards