Background Color Expression in TABLE

[datapitipa]

Hi all,

I have a column in TABLE with this formula ==>  =Interval(Now()-Last_Update_Date,'h')

and I would like show the column green (#93c47d) when this value is >= 48. I tried this, but the background is always white

=if(Interval(Now()- Last_Update_Date,'h') >= 48, '#93c47d', white())

Thanks in advance 

[Peca]

Hi,

You can try this:

=if(Interval(Now()- Last_Update_Date,'h') >= 48, RGB(147,196,125), white())

[tresesco · Accepted solution]

Interval is a formatting function, i.e. - it doesn't change the underlaying number. Try like:

if(Floor((Now()- Last_Update_Date)*24) >= 48, '#93c47d', white())

Note: you might not need floor() based on your requirement.