font colours

[Kayu]

Can I get an excel 2000 formula to return a result in a
different font colour?

Example.

=IF(B3<=(10),"ORDER","OK")

I need this to highlight potential shortfalls in stock levels

Any help much appreciated

 

[Bob Phillips]

Kayu,

You need conditional formatting with the same formula as the worksheet, e.g.

B3<=10 - one colour
B3>10 - another colour

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[drabbacs]

Sure. Check out help info on conditional formatting. You
want to put something along the lines of 'cell value
is', 'less than or equal' and '10' in the three sections.
Then specify the appearance using the FORMAT button.

 

[David McRitchie]

You could use normal cell formatting:

=B3 with a cell format of
[Green][>10]"OK";[Red][>=0]"Out of Stock";;@

Some examples in
http://www.mvps.org/dmcritchie/excel/formula.htm

If you also use Conditional Formatting, the CF will override
normal cell formatting. Some notes on CF.
http://www.mvps.org/dmcritchie/excel/condfmt.htm
--