Howard Katz
asked on
How do I use crbold in a formula?
Hello Experts,
This should be a simple one. Here is my formula. I want the text 'Endorsements located on addendum page' to be bold if @EndNumber > 7.
How do I add the crbold.
IF {@EndNumber}>7 THEN
chr(13) + chr(9) + 'Endorsements located on addendum page.'
ELSE
{@Endorsements}
Thanks
Howard
This should be a simple one. Here is my formula. I want the text 'Endorsements located on addendum page' to be bold if @EndNumber > 7.
How do I add the crbold.
IF {@EndNumber}>7 THEN
chr(13) + chr(9) + 'Endorsements located on addendum page.'
ELSE
{@Endorsements}
Thanks
Howard
ASKER
I put (not in color but in stye)
// This conditional formatting formula must return one of the following Font Style Constants:
//
// crRegular
// crBold
// crItalic
// crBoldItalic
//
If @EndNumber > 7 then
crbold
and I got the error
crbold.jpg
// This conditional formatting formula must return one of the following Font Style Constants:
//
// crRegular
// crBold
// crItalic
// crBoldItalic
//
If @EndNumber > 7 then
crbold
and I got the error
crbold.jpg
ASKER
see comment above
Sorry, Style is the correct place.
you are formatting this formula correct not the @endnumber
IF {@EndNumber}>7 THEN
chr(13) + chr(9) + 'Endorsements located on addendum page.'
ELSE
{@Endorsements}
you are formatting this formula correct not the @endnumber
IF {@EndNumber}>7 THEN
chr(13) + chr(9) + 'Endorsements located on addendum page.'
ELSE
{@Endorsements}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks analliah. You were right the first time only you didn't have the curly brackets around the formula name.
under font, Color >>> click on the x-2
if @EndNumber > 7 then
crbold