Hi all,
I'm hopeful of being able to do this without a macro if possible.
I have a conditional format that evaluates a range of cells and, for each cell where the condition is true, the cell next to it is filled in red.
What I want to do is, where the cell is filled in red, have the text result of that formula display.
For example.
In cell G3 the actual result for April was $406,313.
In cell H3 the budget was $306,297.
In cell I3 the variance of $100,016.
Because the variance is greater than 25% of the original budget figure, cell J3 is filled red as a result of the conditional formatting that I've put in place.
What I would like is for the actual variance of 32.7% to be displayed in cell J3. But I only want the result of this formula to be displayed if the fill is red. If the fill is blank I don't want anything to display in the cell.
Not sure if this is possible but, if so, please let me know.
Bookmarks