LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I re-format the content in populated cells in Excel? Zoey Excel Discussion (Misc queries) 3 December 30th 08 08:40 PM
Formula Content linked to other cells formula Content Flawlesgem Excel Discussion (Misc queries) 5 November 21st 08 11:06 AM
Equal formula keeping both content and format Laetitia Excel Worksheet Functions 9 January 12th 08 08:38 AM
in excel: format font conditional on content of adjacing cell? carl87 Excel Worksheet Functions 2 November 23rd 07 12:07 PM
want format cells alignment not format cells font style Jeannie Bean Excel Discussion (Misc queries) 2 February 10th 06 09:31 AM


All times are GMT +1. The time now is 06:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"