font colours

K

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
 
B

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)
 
D

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.
 
Top