View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Spreadsheet Solutions[_3_] Spreadsheet Solutions[_3_] is offline
external usenet poster
 
Posts: 31
Default Changing font colour for cell variables

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?