How do i do this in Excel please ???

Doosht · 10 Jan 2007 at 17:19

Ive got a "sum" that varies between + and - but i want the box its in to change to either blue or red depending on weather its + or -.

Anyone know how to do this and willing to explain how?

TIA

Doosht

Doosht · 10 Jan 2007 at 17:27

wow i managed to sort it! Impressed myself!

Gopher_By_Fende · 11 Jan 2007 at 08:36

i take it you used the format cell dialog and set it up in there?

PeteLucky7 · 11 Jan 2007 at 08:46

Nah conditional formatting for the win

Doosht · 11 Jan 2007 at 09:08

yes, conditional formatting!

Cheers