I have a column of numbers, all are positive.

  • Thread starter Thread starter Skip
  • Start date Start date
S

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.
 
Is there a way, I can fill the cells with a color, if they are
greater than 30, for example. Thanks for any help.
Click to expand...

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.
 
Back
Top