if bold formula needed

[snowman1976]

hello
i have a column in sheet 1 that lists different items, some are bold text and others are not. the bolding is significant since everyone that uses it understands why things are bolded or not (signifies arrival of goods).

in sheet2, I want to reference sheet one and only return the value in sheet1 if its bolded.
for example in cell A1 (in plain english):

=if(sheet1!A1=bold, sheet1!a1, else "")

i cant find any type of formula that will do this. Does anyone have any thoughts /suggestions how I could do this??

thanks

 

[Jonmo1]

A formula can't refer to the format of another cell, only the actual value.

How are the values bolded? Via conditional formatting?

 

[snowman1976]

no, the user manually unbolds them as the material arrives.

 

[Jonmo1]

Formatting should only be used to make data more appealling to the eyes.
It should not effect the meaning of what the eyes see.

Because it is very difficult to reverse engineer formatting..

I recommend considering a different method to flag the arrival of goods.
Like Putting an X in Column B
Or more usefull would be to enter a DATE in column B when the product arrived.

 

[Jonmo1]

But alas, if you must, this will require VBA.

Press ALT + F11 to open the VBA window.
Click Insert - Module.
Paste the following

Public Function IsBold(c As Range) As Boolean
On Error GoTo Handler
IsBold = c.Font.Bold
Exit Function
Handler:
If Err.Number = 94 Then IsBold = True
End Function

Then you can use the IsBold function to test if a cell is bold.
=IF(ISBOLD(sheet1!A1),sheet1!A1,"")

 

[snowman1976]

hi Jonmo, thanks for the help. I agree that the bolding shouldnt be a reference point, but its been inplanted here for 30+ years and its difficult to make the dinosaurs change procedures.

Thanks for the VBA, this will help tremendously.