Conditional Formula
How is it identifing the cell to compare to?
I am working across a row, not down a column, does this make a difference?
This one has got me stumped!
I need "I3" to flag if it is greater or less than 50% of "D3"
Thanks for the help,
David
"Mike H" wrote:
Hi,
Select A6 then
Format|Conditional format
Cell value is
Less than
=$A$1/2
select green Ok
Click ADD and repeat but this time use 'greater than equal to'
select red
Mike
"David" wrote:
Need help with a formula. (Excel 2003)
Need to create a conditional formula to identify spending trends.
Example:
A1= Alocated Budget, A2-A5= Spending Breakdown, A6= Total Actual Spent
If A6 is 50% or less than A1, flag "Green"
If A6 is 51% or greater than A1, flag "Red"
Thanks
|