Thank you all for your quick responses.

I have tried this and if I type the values, it works, but when I first tried
it with my values being the results of formulas I get a #VALUE error.



"מיכאל (מיקי) אבידן" wrote:

This is all you need:
http://img690.imageshack.us/img690/3036/nonamed.png
Micky


"Mustang" wrote:

Hi there,

I am working in Excel 2003, I have 4 columns as below:
Budget Actual Variance Outside Budget
10000 15000 5000 #
10000 20000 10000 ##

Is there anyway I can set up a formula that will place a # in the Outside
Budget column for every $5000 that is over budget?

Many thanks