Another Excel question

  Ray5776 21:04 28 Nov 06
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 06

Format > Conditional formatting and follow the prompts.

  Ray5776 21:23 28 Nov 06

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.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced