Formula for cells that are only colored and bold

[RobinTMathew]

List of numbers. For example suppose we have 30 cells in one column that each have different numbers. One cell has a number that is bold and font is blue. I want to create a column besides this column that can calculate only if numbers are blue and bold to the left to provide some number in the second column.

Not sure if this is conditional formatting or if I have to use VBA.

If the font is blue and bold in cell A1 then in cell b1 do something. If it is not blue and bold then leave blank.

 

[njimack]

Try the below UDF. Usage would be = Font_Test(A1)

Function Font_Test(r As Range)
With r.Font
    Font_Test = .ColorIndex = 5 And .Bold = True
End With
End Function