Reports: Cell highlighted under certain conditions.

[kplatt]

Hope someone can help me with this question. Should be easy for someone with good experience.

I have a report that i use the following equation with.

=IIf([Sum Of Sum Of Pound Conversion]>=10000,"Hazardous Substance > 10,000 lbs",null)

If the value exceeds 10000 i want the specific cell to read "hazardous substance > 10000". But i also want the cell to be highlighed in yellow only when the phrase appears and not all the time. Any ideas? for example can I add an "and" and color code to the expression? Thanks

Kevin

 

[pbaldy]

Have you looked at Format/Conditional Formatting (on the ribbon in 2007)?

 

[boblarson]

Just use Conditional Formatting instead.

Select the text box while in design view.

Go to FORMAT > CONDITIONAL FORMATTING

and in the Value. It should say VALUE IS and the a blank spot for you to put:

"Hazardous Substance > 10,000 lbs"

and select the color Yellow from the selector.

That should do it for you.

 

[boblarson]

I'm typing too slow

 

[kplatt]

it worked thanks

 

[boblarson]

Paul and I are glad we could help.