Elasticsearch - Update a field of several records already indexed based on a value from a new record still not indexed

Question

I need to update a field of several records already indexed based on a value from a new record still not indexed. Is there any way to implement it?

The table below describes my index with current docs. The yellow line would be a new doc arriving.

RULE: As far the latest entry is received (NEW “not indexed entry”) with STATE=OFF, all respective entries of Group 1 (FROM EXISTING INDEX) must be set COLOR=RED

Could you please let me know any example how to implement?

Thanks

Marcelo