I am attempting to have an area of a graph format differently depending upon the value in a cell outside of this range. (over a certain value - one format, under that value another). The value of the cells in the range do not enter into this calculation.
Is there a way to do this? Most of the conditional formulas seem to be based on the value or contents displayed within the cells of the range.
Bookmarks