Query on Exceptions
I have two columns(key figs) called actual and plan. I have to write an exception such that those Actual values are highlighted which are less than the corresponding plan values.How do i do it?
I tried creating a fromula which was the difference of the two but since the exception was based on the difference only the difference column gets highlighted.but i want deviation in the actual column to be highlighted.
Help would be appreciated