Highlight data from previous day if ...

secolaux — Tue, 18 Apr 2017 13:31:44 GMT

Hello,

I'm trying to highlight some data on a table depending if the value of DB_VehMat is present in a consecutive day.

In this exemple, if DB_VehMat is present the next day, I'd like the first one to be highlight in red.

If the DB_VehMAT is there during 3 consecutive days, I'd like to highlight the first 2. (and so on ...)

Ergo, the result should be something like this :

I think the best way to solve this problem is with the Set Analysis but I can't manage to write a expression which is working as expected.

According to me, the solution should be something like this :

=if(DB_VehMat = "... I need help day+1 ...",red())

Thanks a lot for helping.

S.Colaux

topic Highlight data from previous day if ... in App Development