blank cell result or colored figures

  • Thread starter Thread starter jayvee
  • Start date Start date
J

jayvee

Hi,

Can anyone help me to create a formula for this

column: A B C
( budget ) ( expenses ) ( Result )
1 - 70,000 95,000 -25,000
2 - 70,000 70,000 0
3 - 65,000 50,000 15,000

Question : If the result in column 'C' is

1 - overbudgeted, should show a figure in RED
2 - equal to the expenses, should show a '-' symbol or
blank cell instead of zero'0'.
3 - less than the budget, cell should be highlighted in
blue color.

Is it possible.

Jayvee
 
jayvee said:
Hi,

Can anyone help me to create a formula for this

column: A B C
( budget ) ( expenses ) ( Result )
1 - 70,000 95,000 -25,000
2 - 70,000 70,000 0
3 - 65,000 50,000 15,000

Question : If the result in column 'C' is

1 - overbudgeted, should show a figure in RED
2 - equal to the expenses, should show a '-' symbol or
blank cell instead of zero'0'.
3 - less than the budget, cell should be highlighted in
blue color.

Is it possible.

Jayvee
Click to expand...

To achieve the second, use
Tools > Options > View tab, uncheck "Zero Values".

1 and 3 can be done with Conditional Formatting.
Select C1:C3.
Format > Conditional formatting > Condition 1: Cell Value Is "less than" 0
Choose your red format.
Then click Add>> button
Condition 2: Cell Value Is "greater than" 0
Choose your blue format.

It may be better to put in a small number (say 1 or 0.1) rather than 0 in
each of the conditions, so that any tiny rounding errors do not trigger the
red or blue formatting.
 
Back
Top