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.