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

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.

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

Go to Format-Conditional Formatting

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


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=519504