Another Excel question

  Ray5776 21:04 28 Nov 2006
Locked

Hi all,
using Excell I am trying to get the font colour of a cell to change relative to it`s numeric value.
To use a simple example if the numeric value after being calculated by the formula is 0 or less let the font be black, if it is more than 0 let the font be red.
I would also like the colour change to occur automatically in accordance with the cell value.
I am struggling with this one, can anyone advise please.

Ray

  VoG II 21:07 28 Nov 2006

Format > Conditional formatting and follow the prompts.

  Ray5776 21:23 28 Nov 2006

Ahh yes! thanks Vog, not it used for a while, should have known that.
Thanks for your help once again.

Ray

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?