Conditional Formatting based on rolling month values

[nburaq]

Hi,
I have data shown as below and would like to highlight values based on rule for always last 12 months. In my previous post this was solved bu using formula =SUM(IF(TAKE(FILTER(B2:B25,B2:B25<>""),-12)>30,1,0)) but this time I wanted to highlight cells with this part only TAKE(FILTER(B2:B25,B2:B25<>""),-12)>30 however it does not work well. I will be so glad if someone solve this problem. Thanks in advance !

Datum	Location1
Jan/22	43,70
Feb/22	2,24
Mar/22	28,96
Apr/22	25,57
May/22	41,19
Jun/22	37,42
Jul/22	41,88
Aug/22	37,37
Sep/22	39,31
Oct/22	38,79
Nov/22	37,91
Dec/22	40,40
Jan/23	74,69
Feb/23	59,99
Mar/23	60,69
Apr/23	60,69
May/23	52,00
Jun/23
Jul/23
Aug/23
Sep/23
Oct/23
Nov/23
Dec/23

 

[nburaq]

Thanks one more time, because at the end this was what I wanted to achieve!