How do I change cell color based upon data range within the cell?

C

Chris Sanders

I would like my cell color to change based upon the data in that particular
cell. For instance if the data is <60 = red, <80 = yellow, <100 = red or
something like that.
 
M

mphell0

Go to Format->Conditional Formatting

Set your criteria and click the Format button to set your colors,
borders etc.
 
Top