Fill Color If Statement
 

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.

Fill Color If Statement
 

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.

Fill Color If Statement
 

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.

Fill Color If Statement
 

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.