I am attempting to apply conditional formatting (Highlight cells rule>Text that contains)to cells in range H2:J536 based on whether or not they contain a formula. The dialog box pops up and tells me I can not do that.
The cells I am trying to highlight are results of the subtotal function. How do I diferentiate these cells with color? I am trying to avoid selecting each cell individually.
Some Things I've Tried
Close the groups then select all the visible cells. This did not work it selected all the hidden cells as well.
Used the Select feature to select formulas. This tool was too powerful it selected all the cells that had a formula, not the exclusive cells in the range.
help!!!
![]()
Bookmarks