asked on

Highlight Expert

Does anyone know if its possible to select multiple items and then use the Highlight expert. I have about 30 formulas that I want to apply the exact same highlighting for. Each highlight has 4 conditions, seems like doing each one by hand is a little too much of a pain.

I have tried to select muliple items in the report, but the highlight expert is greyed out.

Any help would be most appreciated!!!!

bob

bdreed35

You can select multiple formulas and set the same property conditionally, such as background color, font, border, etc.
This will allow you to set the formatting condition on multiple fields at the same time.

Select your fields.
Right click one of them and choose Format Field.
For background color, click the Border tab.
Click the X+2 button to the right of background.
In the editor, enter something like the following:

if condition1 = true then
crYellow
else
crNoColor

Save and Close

vmrfadmin

ASKER

Ok, I tried this out and used a nested if then else statement. Here is my statement below.

if {@% Spent Bank Fees} >= 1.00 then
crRed
else
If {@% Spent Bank Fees}>= .75 then
crMaroon
else
If {@% Spent Bank Fees} = 0 then
crBlack
else
If {@% Spent Bank Fees} <= .50 then
crLime
else
If {@% Spent Bank Fees} <= .74 then
crOlive
else
crNoColor

Now....I have the same problem. I have to create a specific snipet of code for each item. I have over 30 formulas and will have to use this code above and each time change the formula value...... such as the one in my example. {@% Spent Bank Fees}

How do you think I should get around this problem?

thanks,
bob

ASKER CERTIFIED SOLUTION

bdreed35

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

vmrfadmin

ASKER

cool, cool, cool.

That is really a neat little trick. Saved me tons of time!!!!!!

Thanks!!!!

bob