I am not entirely clear on what you want, but if I had a list of foods in one column, then in B column the calories, I would go to the Home tab, then Conditional Formatting and work from here, for example, all foods with calories higher than 250 calories, indicate in Red
You could also go to Data > Sort & Filter >...
to pull out only those foods you wanted
|