Conditional Formatting

[choward]

Hi Guys,

In a table on my form, i want to highligh an entire record if one of the elements of that record is above a certain number. I know how to do conditional formatting for individual parts to a record - but not how to say "If Nuns > 5, make Record ID go RED"

any help is appreciated!!! Thanks,

Chris

 

[suepowell]

Hi.

I have done this sort of thing.

I have a table where I want the record to turn yellow if is is a subassembly.

I have achieved this by doing conditional formatting on each field, and using "expression is" as a condition rather than "field value is".
You would then use the expression Nuns > 5 as the condition and set your format in the normal way.

Hope this makes sense, it's a bit of a faff to test every field but that's the only way I know at the moment.

Sue