Hi all,
I am working on a variance analysis file for my company comparing new versus old prices (2013 versus 2012). Using conditional formatting, I want to highlight variances larger than |50%|.
The formula I am using to calculate the variance is:
=IFERROR((E2-F2)/F2,"no data")
where E2...