'IF' formula=true if subject is BOLD

[jamiepullen]

i posted this in the worksheet functions forum, but didnt get any replies. is it more of a vba problem?

http://www.excelforum.com/showthread.php?t=647843

i want any text in column 'B'on 'sheet1' to equal a 1 in the same number cell in column 'AZ' on 'sheet2' if it is bold. i also want the cells in column 'BA' on 'sheet2' to equal a 1 if the text in 'B' on 'sheet1' is red

Can this be done?

Regards, jamie

[Rick_Stanich]

This will read the values in column "AZ" based on BOLD or RED text and duplicate the values from column "A" to column "B".

Please Login or Register  to view this content.

[jamiepullen]

off out now. will give a go tomorrow and let you know. thnks for the reply!!

Is there a way to include bold or red as the subject of a formula out of interest?

regards,jamie

[Rick_Stanich]

This line "If Sh1Cell.Font.Bold = True Or _" test for BOLD fonts
while this line "Sh1Cell.Font.ColorIndex = 3 Then" tests for RED fonts.