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.

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


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Elgee" wrote:

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.

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

"Elgee" wrote:

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.

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!

"Mike H" wrote:

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

"Elgee" wrote:

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.