Color Fill Cell Based on Criteria

Hello,

Looking for help w/ color filling based on criteria. I would like to use something similar to the find and replace feature.

example:

Find all cells w/ 8 or less and fill cell w/ green color.

some numers a not whole and have Decimals like: 7.25 and 6.50...just to list a few.

Using Excel 2007.

Thanks for your help.

Frankee.

Simon,

Thanks...it worked.

I have another challenge. I share this same spreadsheet w/ another co-worker who has Excel 2003. Excel 2003 changes the colors of my rows.

To fix, I currently select every other row and fill the color w/ my original color...not Efficient.

I would like to use a tool that will allow me to select every other row and fill w/ color of my choice.


Thanks Guys.