Hi,
You can use the Excel feature called COnditional Formating:
- Select cell A1
- go to menu Format Conditional Formatting, choose:
'Cell Value Is' 'Greater Than' and enter 5
Click the Format button and choose the green pattern
Click OK
Click
From now on, the cell will be green when the value is greater than 5 and
regular format when less than or equal to 5

Regards,
Sebastien

"Jeff" wrote:

Does anyone know how to use an IF statement to change the color of a cell??

An easy example: =IF(A1<=5,1,0). Can I change the value_if_true or
value_if_false to change the color of the cell?

Could probably read: =IF(A1<=5,1,"cell=green")

Thanks.