Format cells and font by content/whether formula present
 

This is a suggestion to make it simpler to change the color/formatting of
fonts and cells, in essence, an extension of Conditional Formatting. In
Finance, and no doubt other industries, it is useful to determine whether a
cell has a formula (not a specific formula, but whether any formula of any
type is present) or if it is merely a number or name. The function would be
for Excel to apply cell formatting purely based on the existence, or lack
thereof, of any formula.

For example:
A1: 350,000
A2: = A1/10
A3: = A2*6

Using the function, you could apply formatting to A2 and A3 without
specifying the exact formula that exists, but rather, that a formula is
present. Similarly, A1 could also have formatting applied since it contains
no formula.

----------------
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

Format cells and font by content/whether formula present
 

Press F5 Special Check "Formulas" OK
will select all cells in the sheet with formulas in one swoop
You could then apply whatever formatting desired

Similarly ...
Press F5 Special Check "Constants" OK
grabs all data cells in the sheet (w/o formulas)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"LJT87" wrote:
This is a suggestion to make it simpler to change the color/formatting of
fonts and cells, in essence, an extension of Conditional Formatting. In
Finance, and no doubt other industries, it is useful to determine whether a
cell has a formula (not a specific formula, but whether any formula of any
type is present) or if it is merely a number or name. The function would be
for Excel to apply cell formatting purely based on the existence, or lack
thereof, of any formula.

For example:
A1: 350,000
A2: = A1/10
A3: = A2*6

Using the function, you could apply formatting to A2 and A3 without
specifying the exact formula that exists, but rather, that a formula is
present. Similarly, A1 could also have formatting applied since it contains
no formula.

Format cells and font by content/whether formula present
 

A few suggestions found in this google search.

http://tinyurl.com/8dw5ly


Gord Dibben MS Excel MVP

On Wed, 7 Jan 2009 15:16:30 -0800, LJT87
wrote:

This is a suggestion to make it simpler to change the color/formatting of
fonts and cells, in essence, an extension of Conditional Formatting. In
Finance, and no doubt other industries, it is useful to determine whether a
cell has a formula (not a specific formula, but whether any formula of any
type is present) or if it is merely a number or name. The function would be
for Excel to apply cell formatting purely based on the existence, or lack
thereof, of any formula.

For example:
A1: 350,000
A2: = A1/10
A3: = A2*6

Using the function, you could apply formatting to A2 and A3 without
specifying the exact formula that exists, but rather, that a formula is
present. Similarly, A1 could also have formatting applied since it contains
no formula.

----------------
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