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.