Yes, the UDF doesn't work for CF,
as pointed out by Ron in his post
(you didn't say the "bold" was coming from CF
in your orig. post)
If it's meant to reproduce the CF condition,
it's simpler, as per example posted by Peo
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Brian" wrote in message
...
B1's font is made bold via conditional formatting which is not recognized
as
bold by the formula you provided. I checked B1 and found that although
cond
formatting made content of B1 bold it still indicated in the format menu
as
regular. So therefore the formula is not finding any cells to be bold even
though they may appear to be.
can something be added to fix this problem?
Thank you
Brian