Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

Formate Finder

Hi Experts,


There is any way to find bold text from column & highlighted Cell.

I.E.
Column A     Column B                                                Column C
xyz                =if formula to find A1 is bold or not   = if formula for find it is highlighted or not
ABC
123
567


Thanks
0
Naresh Patel
Asked:
Naresh Patel
  • 6
  • 4
  • 3
2 Solutions
 
Paul 1Commented:
you can do it with VBA if you know how using (If .Cells.Font.Bold Then)
0
 
Naresh PatelTraderAuthor Commented:
there is no way out via formula?
0
 
Paul 1Commented:
effectively you are creating a custom formula

see here for step by step
http://chenected.aiche.org/tools-techniques/excelling-with-excel-1-2/
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Robberbaron (robr)Commented:
as Paul notes, the bold is easy enough.  see below and example sheet with code

but what do you mean by Highlighted.   do you mean currently selected, or mean that it has a background color ?
Function IsCellBold(cellx As Range) As Boolean
    If cellx.Font.Bold Then
        IsCellBold = True
    Else
        IsCellBold = False
    End If
End Function


Function isCellBackground(cellx As Range) As Boolean
    If cellx.Interior.Color = RGB(255, 255, 255) Then
        isCellBackground = False
    Else
        isCellBackground = True
    End If
End Function

Open in new window

format-test1.xlsm
0
 
Naresh PatelTraderAuthor Commented:
Hello Sir  robberbaron,

but what do you mean by Highlighted.   do you mean currently selected, or mean that it has a background color ?


Answer : - Highlighted.

Do I able to use this function in my all workbooks?
i.e. whole PC even in newly opened?


Thanks
0
 
Paul 1Commented:
if you save it as a template it will work - you could replace the default blank
0
 
Robberbaron (robr)Commented:
1. I still need more detail on what you mean by highlight..... in excel terms :-)

2. if you save the macro in a workbook and then add that workbook to the default folder, it gets loaded at excel start.  http://office.microsoft.com/en-au/excel-help/customize-how-excel-starts-HP005199391.aspx
Use the XLStart folder

Any workbook, template, or workspace file you place in the XLStart folder is automatically opened when you start Excel. This XLStart folder was created when you installed Excel, and is located in one of the following places:

C:\Documents and Settings\username\Application Data\Microsoft\Excel
C:\Program Files\Microsoft Office\Office11
 the latter applies for all users of the PC
0
 
Naresh PatelTraderAuthor Commented:
Highlited
0
 
Naresh PatelTraderAuthor Commented:
Thanks
0
 
Robberbaron (robr)Commented:
ok. what you really mean is that is has a background color.

my isCellBackground function tests for this.
0
 
Naresh PatelTraderAuthor Commented:
yes sir


thanks
0
 
Naresh PatelTraderAuthor Commented:
Sir I had placed this file to
C:\Program Files (x86)\Microsoft Office\Office14\XLSTART

Open in new window

location & restart the pc but cant find this function on new workbook. save as .xltm



Thanks
0
 
Robberbaron (robr)Commented:
on my machine, xlstart folders are

C:\users\rob\appdata\roaming\Microsoft\Excel\xlstart


c:\program files(x86)\Microsoft Office\Office12
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 6
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now