Forum Discussion
If Statemnt - Volatile result
Sergei, Thanks for the reply. Here is a screen shot of the issue. I have highlighted in the Formula dialogue box the issue.
Richard, I see, thank you for the screenshot. That's not an error, that's kind of alert which says you use so called volatile functions. In this case that is TODAY(). Excel recalculate all volatile functions with every operation in the sheet, even if such function has no connection to this operation at all. Thus such functions could significantly reduce the performance of all calculations.
I guess Excel doesn't show result at this very moment for such functions since they are recalculated all the time.
You may simply ignore this "formula result".
Sergei,
Thanks for the reply and yes that would explain the "Volatile" result of the formula.
What doesn't make any sense is that this functions works perfectly elsewhere on the worksheet.
The only difference is that the conditional formatting is on data values that have a hyperlink associated with them this time. On the row that it is working on there are no hyperlinks.
Thanks
Richard