Forum Discussion
benjaminherremans
Jul 31, 2024Copper Contributor
Last time a specific data appear
Hello everyone I have a table where I keep track of which supplement my birds have got. In column A is the date the bird received the supplement. Column B is the type of supplement it got. Column...
m_tarler
Aug 01, 2024Bronze Contributor
benjaminherremans you can use this in the conditional formatting custom rule:
=$A1<MAX(($A$1:$A1 + $C$1:$C1)*($B$1:$B1 = $B1)*($A$1:$A1<>$A1))
assuming date of use is column A and the Applied to range starts in A1
alternatively if you have the conditional formatting Applied to range start in A2 then:
=$A2<MAX(($A$1:$A2 + $C$1:$C2)*($B$1:$B2 = $B2))