Hey All,

I'm by no means a pro at this, so I would appreciate some help finding a solution.

I am creating a database which will contain a sequential set of commands for a group of people. The database needs to be editable.

I think the best way to describe my problem is by example. Say I have 10 records.

In rec2: Field 1 = "ON"

In rec5: Field 1 = "OFF"

In rec8: Field 1 = "ON"

I'd like to make use of conditional formatting so that in rec2 through rec4, a field is bold, then in rec5 through rec7, the field is not bold, and so on and so forth.

I don't know how to make it look back in the sorted list to see what the last non-empty record is.

If you need me to explain it differently, please let me know.

Thanks,

Alex

If I'm understanding you correctly.

Use the Conditional Formatting with a formula of

Self = "ON"

then select the Bold as the Format.

HTH

Lee

You could try something like the attached.

Keep in mind that the cascading calculation is unstored, and may prove too slow for large found sets.

Cascade.fp7.zip

That did the trick.

Thanks for the help!

Alex