How can I conditionally format individual items in lines of a repo

D

dmhix

I need to be able to underline product catalog numbers and names in my weekly
sales report that fall below certain sales criteria. Items in report must be
in catalog number order so items are interspersed within the report body. Is
there a way to do this?
 
M

Marshall Barton

dmhix said:
I need to be able to underline product catalog numbers and names in my weekly
sales report that fall below certain sales criteria. Items in report must be
in catalog number order so items are interspersed within the report body. Is
there a way to do this?


Try using Conditional Formatting (Format menu) on the number
and name text boxes. Specify your "certain sales crtieria"
in the Expression Is: box and select the Underline format.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top