Conditional formatting.

Select the cells.
FormatConditional Formatting.
Change the dropdown to less than, and 1 in the value box
Click format, select Pattern, select red
OK
OK

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Tracy D" <Tracy wrote in message
...
Hi,
I am trying to set up a IF statement that if true would make the cells a
certain colour. Specifically, if the number is less than 1, make red. Is
this
possible to do with an IF statement?

Thanks,

Tracy