Need to modify data from DB

[Ferrora]

Hello,

I have slight problem with my code. I have code that extracts data from DB and put it in table. Example:




So I need that cells on L column are lighted (red for example) if the data is repeating itself for 3 shifts. Or at least i need a way i could see when data is repeating.
The idea is that i extract data that is out of specific range.


Code:
sql = "SELECT ID, (SELECT Number FROM WindingStands WHERE ID = TexMeasurements.WindingStandID) as Place, SpindleNumber, " _
& "(SELECT Number FROM Assortments WHERE ID = TexMeasurements.AssortmentID) as Sifrs, " _
& "(SELECT Name FROM Assortments WHERE ID = TexMeasurements.AssortmentID) as Sort, CreationTime, TexPV, TexSP " _
& " FROM TexMeasurements " _
& " WHERE CreationTime > " & fromdate & " AND CreationTime <= " & ToDate & " " _
& " AND (TexLimit <= -3 OR TexLimit >= 3) ORDER BY Place, SpindleNumber, CreationTime"


I hope somebody could help me with this.

 

[Ferrora]

For some reason cant update picture

 

[Ferrora]