Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Search a cell based on format
What is the formula (if statement?) to select a cell based on format. For
example, if the cell is "bold" then I want the contents of that cell. Otherwise, blank. |
#2
|
|||
|
|||
That is impossible with built-in formulas, sorry. You'd have to code
something in VBA. HTH. Best wishes Harald "Al" skrev i melding ... What is the formula (if statement?) to select a cell based on format. For example, if the cell is "bold" then I want the contents of that cell. Otherwise, blank. |
#3
|
|||
|
|||
There is no such function built in, Harlan Grove has written extcell which
has that built in (among many other things), it can be downloaded here ftp://members.aol.com/hrlngrv/ExtCell.zip Then when you have imported it into the VBE you can make it an add-in and always available There are probably other add-ins with this functionality to be found online Regards, Peo Sjoblom Regards, Peo Sjoblom "Al" wrote: What is the formula (if statement?) to select a cell based on format. For example, if the cell is "bold" then I want the contents of that cell. Otherwise, blank. |
#4
|
|||
|
|||
Forgot some info, once you have imported it (from a new workbook press Alt +
F11, click fileimport and import it), then save as *.xla, then go to toolsadd-ins and check it. Finally to use it =EXTCELL("bold",A1) will return 1 if cell is formatted bold, so with regards to your specifics =IF(EXTCELL("bold",A1)=1,A1,"") there are a lot of other functions built in as well, there is no help file so you need to open the bas file in notepad for instance and print it since each function has it's own description Regards, Peo Sjoblom "Peo Sjoblom" wrote: There is no such function built in, Harlan Grove has written extcell which has that built in (among many other things), it can be downloaded here ftp://members.aol.com/hrlngrv/ExtCell.zip Then when you have imported it into the VBE you can make it an add-in and always available There are probably other add-ins with this functionality to be found online Regards, Peo Sjoblom Regards, Peo Sjoblom "Al" wrote: What is the formula (if statement?) to select a cell based on format. For example, if the cell is "bold" then I want the contents of that cell. Otherwise, blank. |
#5
|
|||
|
|||
You could use old XLM.
1. Define a name (Ctrl+F3) as: =GET.CELL(20,INDIRECT("rc[-1]",0)) and name it "isbold" (no quotes). 2. Place this formula to the immediate right of the cell you are evaluating. For example, if you are evaluating A1, place this in B1: =IF(isbold,A1,"") Note that making cells bold/non-bold won't recalculate the formula. You must do a recalc on the worksheet. HTH Jason Atlanta, GA "Al" wrote: What is the formula (if statement?) to select a cell based on format. For example, if the cell is "bold" then I want the contents of that cell. Otherwise, blank. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
How do I format a value when using it within a cell reference tha. | Excel Worksheet Functions |