On 10/16/2011 at 9:18:48 AM Skip wrote:

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.

--
tb