VBA Express Forum
>
VBA Code & Other Help
>
Excel Help
> Solved: Formula for Conditional Formatting
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%
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.