How can I modify this function so that If it returns a 0 due to no change in
data, it will not interrupt Conditional Formatting? I have CF set to show 2
standard dev and above, but it won't work with this formula.

=(VLOOKUP($Q842,Import!$Q:$CA,3,FALSE)/(VLOOKUP($Q842,'Old
Import'!$Q:$CA,3,FALSE)))-1
--
Thank you!