I have a column of numbers, all are positive.

[Skip]

Is there a way, I can fill the cells with a color, if they are
greater than 30, for example. Thanks for any help.

 

[Gord Dibben]

Have a look in Help under the topic Conditional Formatting


Gord

 

[James Ravenswood]

Is there a way, I can fill the cells with a color, if they are
greater than 30, for example. Thanks for any help.

See Conditional Formatting in Excel Help or:

http://www.contextures.com/xlCondFormat01.html

 

[tb]

Is there a way, I can fill the cells with a color, if they are
greater than 30, for example. Thanks for any help.

These instructions work for Excel 2007:
* Highlight all the cells that have values in them
* Within the Home tab, select the Conditional Formatting icon
* Select Highlight Cells Rules
* Select Greater Than
* Insert the value 30 in the Format Cells That Are GREATER THAN cell
* Pull down the menu on the right side and chose according to your
desires.