Hello I am using Execl office 2016 for Mac
I like to me a text bold but it is depending of the result

=IF(AJ23>0;"Heading total";IF(O23>0;O23;" "))



IF it has to show the text " heading total " i want it bold but if it is the
result of O23 I like to have it normal.

Is that possible

HI,

I do not think what you want can be done with a "Formula". It can be done with code.
But, in order to do it with code we need to know at what time you need the "Bold" action is to take place. That is if you enter data in a specific cell or some thing of this nature.

Thank you for your Message my problem what I have that I never know where the Heading total will come in the column it is depending of how of the equipment list.
in the M column i am tell where the subtotal has to start

Attached Files

Quote-excel.xlsm (206.8 KB, 8 views)

Have you tried conditional formatting?
Have a look at this article.

Hi,

If you would clarify your request. Give a example as to what you do. What is the first thing you do and what is the expected result. What is the second thing you do and what is the expected result.

Thank you all!!!

Yes NoSparks that is the way to do it thank you it works perfect!!