View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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