Another Excel question

  Ray5776 21:04 28 Nov 2006

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.


  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.


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

Elsewhere on IDG sites

Samsung Galaxy S9 review: Hands-on

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?