You should have a look at conditional formatting

"Tracy D" wrote:

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