Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I re-format the content in populated cells in Excel? | Excel Discussion (Misc queries) | |||
Formula Content linked to other cells formula Content | Excel Discussion (Misc queries) | |||
Equal formula keeping both content and format | Excel Worksheet Functions | |||
in excel: format font conditional on content of adjacing cell? | Excel Worksheet Functions | |||
want format cells alignment not format cells font style | Excel Discussion (Misc queries) |