LinkBack URL
About LinkBacks
Is there a formula that I can use to tell me how many cells in a range are either bold or underlined?
Is there a formula that I can use to tell me how many cells in a range are either bold or underlined?
Unfortunately not
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Not a standard Excel function that I know of. It may be possible using old Excel 4.0 macros, failing that it would need a custom VBA function.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Some would argue that storing data in a format is not the proper method anyway. If your formatting is supposed to convey a certain meaning, then that meaning should be stored in a seperate column (either as text or a number) so that sorting, filtering, counting, averaging, etc. can be applied. For presentation purposes you may need to hide this extra column and use conditional formatting to preserve the look of the underlined/bolded text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks