I would like to have a the formatting of a range of cells determined by the value in a cell outside the range.
Please note that the value of the cells within the range is not a factor in the formatting decision. Only the value in the cell outside the range.
The rules that seem to be available SEEM to be based on comparing values of the cells within/without the range.
Bookmarks