How do I achieve this as a formula Green if before and red if after Today()
Create a formula field with this code:
---
styled(text('Renew By'), if 'Renew By' <= today() then"green"else"red"end, "")