If you want to include it in your VBA code, you're right, you would use the
If statement:

If ActiveCell 1000 Then
Activecell.Font.ColorIndex = 3
Else
Activecell.Font.ColorIndex = 5
End If

Depending on the colours you want, you will either need to use trial and
error (by picking a number and then stepping through the code to see what the
result is), looking up the help or recording a macro and selecting the colour
that you want. Then you can look through what you recorded and get the
colour index.

Hope this helps.



"Spreadsheet Solutions" wrote:

Try conditional formatting !!!!

--
--
Met vriendelijk groet;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Nederland
--
E:
W: www.spreadsheetsolutions.nl
--
"Sea Urchin" wrote in message
...
I want to be able to change the font colour in a cell depending upon it's
value in the cell - eg over/under 1000. Presumably the 'IF' function is
the
way to go but what do I need to do to get it to change the font colour.
Can
anyone help?