Conditional Format based on Last Added Value

[Franco_Moltedo]

Hello, I need to create a format that checks wether the last value of a given entry is TRUE.

Data is organized in this way:
REGISTERS contains entries for all the EQUIPMENTS (which are also listed on a separate table).
One of these criteria is wether EQUIPMENT was registered operative (TRUE/FALSE).

I have a format that works for every register individually, but doesn´t work for the agregate value.

How can I apply the format in the menu tab, so that when I want to select any given EQUIPMENT, it applies the color of the last register written for it?

Thanks!