Complex criteria for conditional formatting

[Jarvis]

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 October 18, 2007 by Guest

[Lee Smith]

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

[Jarvis]

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!

[Lee Smith]

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 October 18, 2007 by Guest
p.s.

[Jarvis]

Thanks for that link Lee.

I downloaded your sample file.

The code is very elegant.

Jarvis