shading cells

[djackson]

Say at a certain range I wish to highlight a cell or entire row. For a
example anything 50.00% and higher is highlighted red

 

[Frank Kabel]

Hi
have a look at conditional<formating. See the following for more
details:
http://www.cpearson.com/excel/cformatting.htm
http://www.contextures.com/xlCondFormat01.html

 

[JE McGimpsey]

Check out Conditional formatting in XL Help.