"Format" function in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barrett at Tyndale - 08 Feb 2006 21:11 GMT

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.

Reply to this Message

Niek Otten - 08 Feb 2006 21:17 GMT

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

Signature

Kind regards,

Niek Otten

> Excel currently does not have the ability to conditionally format from a
> function. When writing complex formulas regarding a range of data, it
[quoted text clipped - 14 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=0dc29925-4012-4
90a-80db-f140e5d8a5ac&dg=microsoft.public.excel.worksheet.functions

Reply to this Message

Obi - 25 Oct 2006 10:24 GMT

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

> Excel currently does not have the ability to conditionally format from a
> function. When writing complex formulas regarding a range of data, it would
[quoted text clipped - 12 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=0dc29925-4012-4
90a-80db-f140e5d8a5ac&dg=microsoft.public.excel.worksheet.functions

Reply to this Message