Conditional formatting differente range with formula

Hello everyone, I m Looking for some help for a conditional formatting in Google sheet,

the sheet is divided in column from F to R, we have to write the number of item that we sell every month.
all the item are dived by category by a gray ROW,
the conditional formatting that I m looking need to highlight in green the higher sales, red the lower, yellow the middle sales, and the formatting need to highlight the value for every single category( example category 1 is from f3:f17, category 2 is from f19:29 etc.....) month by month
I try to copy the conditional formatting but the formula will not update and i have to update manually, is there any dynamic formula that can be used?

i do apologies in advance if I m Not totally clear and I will really appreciate is someone can help

in attached the file

thank you in advance

Dear AliGW

well noted and thank you so much sorry for the mistake

Hi janmorris, sure here the link to the file

https://docs.google.com/spreadsheets...it?usp=sharing

Hi janmorris

I added a column A with a category drink and food, column B it will be kind Of drink of Food name,Am I correct ? and what it will be the formula to match my request? vlook?

thank you so much in advance.

Hi janmorris

so the formula that you propose me it work perfectly, just to understand a bit better the arrayformula is looking for the subcategory name,in the column B, once he define where all the item of the same sub category are , it proceed to look for the lower or higher or second value of the sub category, am I correct ?

thank you for the help and also for bonus formula

Hi janmorris

thank you so much for the explanation

have a nice day