Fill Color If Statement

E

Elgee

Hi -
In a workbook I track project financials. IE: Forecast, Actuals, Variance
etc.
Cell A2= Forecast
Cell A3= Actuals
Cell A4 = Variance

I would love for cell A4 (variance) to auto-fill a color if it is greater or
less than a certain $ amount of or percentage of cell A2.

For example - if Forecast = 100,000, and the Actuals are 50,000, the
variance = 50,000 - the variance cell should be filled with a color to call
out that the # is greater than or less than 50% or $50,000 of the forecast.

The dollar amount and % are just examples - I would just like to use one or
the other.

Thanks so much for your help.
 
W

Wigi

Please dig into conditional formatting, since this is definitely what you
need here.
 
M

Mike H

Hi,

Select A4 then
Format|Conditional format
select formula is
paste in the formula
=A4<=ABS(A2*0.5)
Pick a colour
Click OK

Mike
 
E

Elgee

Hi -
Thanks for your help - I was making it harder than necessary.
What I really needed was 'if the value of the cell is >5000 then fill...'.
Which I know I can do with Conditional Formatting.

Thanks Mike and Wigi!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top