Visual indication of energy usage (surplus or not) of the house

Hi all, I am looking a while now for a solution but there is nothing out there I can use (my programming skills are not very good ;-))

I want to make it possible to have a Hue light to visual indicate how the energy usage of the whole house (energy production - energy usage = energy potential) is at the moment. Green lamp is when there is a surplus (energy potential is higher than 1000 watt, orange for 200 to 1000 and red for < 200 or less).

I have a Hue Bridge configured in HA, Smart Meter for my P1 and Solax API for solar panel info.

How can I do this in Home Assistant?