Format cells and font by content/whether formula present

[LJT87]

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

 

[Max]

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

 

[Gord Dibben]

A few suggestions found in this google search.

http://tinyurl.com/8dw5ly


Gord Dibben MS Excel MVP