<Format
<Conditional Formatting
In the second drop down box choose "Less Than"
Enter 7
Click "Format" and choose a red cell format

--
Regards,
Dave


"donschap" wrote:

I'm trying to change the fill color of a cell based on a condition (value)..
FOr example if a value is less than 7, fill the cell color in red