excel 2007 calculation help

  Boy Zone 11:16 29 May 2010

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

Huawei MateBook X Pro review

8 digital brands that designed custom typefaces to save millions

How to speed up a slow Mac

Comment résoudre des problèmes d’impressions ?