We want to create a custom field RAG_STATUS on the Supplier Info header screen.

if Insurance Renewal Request = ‘YES’ THEN RAG_STATUS = ‘GREEN’

If Insurance Renew Requested = ‘NO’  and Insurance Renewal Date has not expired but is >= TODAY’S DATE -30 DAYS then RAG_STATUS = ‘AMBER’

If Insurance Renewal Date has expired then RANG_STATUS = ‘RED’

Finally, if possible we would like the field to highlight the RAG_STATUS field in the colour of the RAG_STATUS answer.

Probably achieving the above via a custom event.

Any ideas on how I can achieve this.