Thank you for responding. The error turned out to be the double quotes that
I had input for a "false" response. The value should be zero. Thanks,
again.



"Shane Devenshire" wrote:

Please explain what formatting you are trying to do and how. Are you saying
that you can't bold the cell?

What version of Excel are you using?

Are you applying formats to a table range?

Are you using conditional formatting?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"EnigmaKat" wrote:

Thank you for responding. The formatting that is in the cell when the
function is written gets overridden and I can't change it manually. When I
open the formatting dialogue box, the selections are still in place but the
cell does not reflect the style.




"Pecoflyer" wrote:


EnigmaKat;197108 Wrote:
=IF(AND($U4=DHARMA!G$4,$U40,$O4<"H"),$E4*DHARMA! $H$4+$F4*DHARMA!$I$4,"")&IF($P4<0,$P4*DHARMA!$H$4 +$Q4*DHARMA!$I$4,"")

After several rewrites, this function works and does not return an
error
when the cells are blank, but now I can't format the cells that contain
this
function. Strange.

What do you mean by formatting?
Manual, conditional ?
What goes wrong?


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54300