font colours

  • Thread starter Thread starter Kayu
  • Start date Start date
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
 
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)
 
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.
 
Back
Top