PDA

View Full Version : Solved: Formula for Conditional Formatting



BENSON
01-12-2009, 04:55 AM
What is the formula to have in conditional formatting if a projected sales amount is within 10% either way +- of an actual sales amount

THANKS

Bob Phillips
01-12-2009, 05:10 AM
Try

=ABS(1-actual_amount/projected_amount)<=10%