Jump to content

Complex criteria for conditional formatting


This topic is 6089 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a columnar type layout that I use to manage work orders for my cabinetshop.

The initial formatting for all fields is black fonts with white fill patterns.

If the value in PRIORITY field is set to "hot" I want all of the fields in the record to display in [color:red]Red Fonts and I want the fill patterns to remain white.

If the value in STATUS field is equal to "In Process" I want the fonts to become black again but I want the fill patterns to become green.

Is there a way to conditionally set this formatting to switch from one format instruction to another?

Thanks for any help,

Jarvis

Edited by Guest
Link to comment
Share on other sites

You don't need to use Conditional Formatting for this, we have been doing this with a calculation since the release of v7.

You can use a straight Calculation,

or,

and Auto Enter Calculation,

or the Conditional Formatting.

Do a search of the Forum for Text Formatting Calculation, and you should find plenty of examples. Use the Pluse signs to narrow down the search (i.e. +text +Formatting +Calculation)

HTH

Lee

Link to comment
Share on other sites

Thanks Lee!

As I understand it I can only get to conditional fill patterns via conditional formatting in FM9. I've achieved this effect in the past with transparent data fields over colored container fields but I was hoping to minimize the acrobatics this go around

I will look in the archives as you suggest.

I am hoping to find something that will help me develop a hierarchy of formatting, i.e., allowing one set of formats to trump another based on a condition.

Thanks again!

Link to comment
Share on other sites

I posted a file not long ago that did the fill patten.

Here

Look at the Bottom Field's Conditional Formatting.

Lee

p.s.

The whole tread might be of help.

Edited by Guest
p.s.
Link to comment
Share on other sites

This topic is 6089 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.