excel 2007 calculation help

  Boy Zone 11:16 29 May 2010
Locked

Hi,
A real small problem that I'm trying to overcome.

I want to show the difference between two cell values i.e. subtract one from the other (simple enough) and if value is smaller then the other to show it's value in RED and if larger show the value in GREEN.
When I do this it seems the work visa versa..?

  VoG II 11:26 29 May 2010

Say the formula in C1 =A1-B1

Select C1, Home tab, Conditional Formatting, Highlight Cell Rules, Less than, enter 0, set fill to red, click OK.

CF again, Manage Rules, New Rule, Format only cells that contain, Cell Value, Greater than, enter 0, format as green, OK your way out.

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

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Aardman's new YouTube channel to share the work of independent animators

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017