If Statemnt - Volatile result

[RichardB-257397-242020]

I am doing Conditional Formatting on a date field. For 1 data set it works fine. When I try it on another data set it is not working.

When testing the IF statement, it appears that result rather than True or False I get the result Volatile.

Can anyone suggest a fix for this.

Thanks

Richard.

[#2]

@RichardB-257397-242020 

Richard, is it possible to receive small sample file or at least screenshot of how it looks?

[#3]

@Sergei Baklan 

Sergei, Thanks for the reply. Here is a screen shot of the issue. I have highlighted in the Formula dialogue box the issue.

[#4]

@RichardB-257397-242020 

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".

[#5]

@Sergei Baklan 

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