"Format" function in Excel

G

Guest

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
 
N

Niek Otten

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top