So here's my latest conundrum.
I have a table that keeps track of when particular types of parts need to be rebuilt or thrown away- each part type has a 'caution' and an 'nfg' value (NFG being the term our engineers use for a part that's outlived its usefulness- I'll let you ponder what it means).
I also have forms set up to display individual parts by serial number as well as their total mileage (and various other metrics).
What I'd like to do is have the control (a text box) that displays the total mileage for a given part to change the back color to yellow if the mileage is greater than the caution value in the table, and then if it's past the NFG value, change the back color again to red.
I've attempted to use the conditional formatting tool with a query (setting up sequential rules for caution and nfg) but that doesn't appear to work, possibly because I'm building the expression wrong. I've tested the query and it returns the correct values.
I can just set up the controls directly by entering the mileage thresholds numerically in the conditional formatting tool, but I'd much rather have a table I can quickly edit.