Is Conditional Format Bold Really Bold??

[bc4240]

I have been looking at Excel Magic Trick 1355 and want to create a similar result. However due to some original data issues, I am having to conditionally format my data column to make the "Parents" bold rather than manually converting them to bold. As a result the IsBold function I created with =GET.CELL(20, !A1) does not recognize the conditionally created bold as bold. Is there another code rather than (20) for this situation. Any ideas about how to fix that ??

Is there a list of these Get.Cell codes somewhere?

 

[Fluff]

Get.Cell does not recognise CF format, the cell has to be manually formatted.
There is a list of the various arguments here

Info only - get.cell arguments

Get.cell (an old xl 4 macro function) can be used to return more info about the worksheet environment than is available with the cell() function. No VBA code (or skills) are required. One complication is that you cannot use get.cell directly in the worksheet. However, there is a...

www.mrexcel.com

 

[bc4240]

OK great thanks for the info

 

[Fluff]

My pleasure