View Single Post
 
Old 11-26-2009, 01:30 PM
zyzzyva57 zyzzyva57 is offline Windows Vista Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

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
Reply With Quote