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?

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?

Hi

Look at Conditional Formatting on the Format menu.

Hopes this helps.

---
Per

"Sea Urchin" skrev i meddelelsen
...
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?

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?