Highlight data from previous day if ...

[secolaux]

Hello,

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

BD_date	DB_VehMat
01/01/2016	123aze
01/01/2016	456qsd
01/01/2016	789wxc
02/01/2016	123aze
02/01/2016	896edc
02/01/2016	963tgj
03/01/2016	123aze
03/01/2016	456qsd
03/01/2016	963tgj

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 :

BD_date	DB_VehMat
01/01/2016	123aze
01/01/2016	456qsd
01/01/2016	789wxc
02/01/2016	123aze
02/01/2016	896edc
02/01/2016	963tgj
03/01/2016	123aze
03/01/2016	456qsd
03/01/2016	963tgj

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