Excel- changing the color of a cell if the value reaches the given level

What function or macro should I use if I have two columns: in the first, for example Fruit, and in the second, weight, and if I weigh more than 3 kg, I want to highlight the numerous B's in red, but at the same time I have a list of fruits, the weight of which can reach 5 kg, and then it has light up red. I know you can use conditional formatting for this, but the fruit list can change and there are a lot of records and I don't want to do it manually.

Thank you in advance for your help

Motylek1997 wrote:

I know you can use for this conditional formatting , but the fruit list may change, and there are a lot of records and i don't want to do it manually.

Formatting conditional - as the name suggests, this is not formatting handmade :not:


Show the file, someone will suggest a conditional formatting formula.

Now I can only send photos ie

Hello
Conditional formatting can be declared for single cells as well as for entire selected areas.

Watch the training video
http://excelszkolenia.pl/FormatowanieWarzeniaowe.htm


Regards