If statement on format

[eyeldham]

Can an if statement evaluate the format of a cell?

Could it return one result if the cell is highlighted in bold (or a colour) whilst returning another if it is unformatted?

Used if statements a lot but this would be a help if it could achieve this.

Ed

 

[JamesW]

Hi Ed,

You can do this with VBA, but not with excel functions (unless you create a UDF of course).

Function isBold(myCell As Range) As Variant
    Select Case myCell.Font.Bold
        Case True
            isBold = True
        Case False
            isBold = False
    End Select
End Function

=isBold(A1)

Note, this will only work for one cell at a time.

 

[Expiry]

If you're using conditional formatting, you can use the same conditions to get the result you want.