i'm using a macro to determine which pages to print, if there's formula which
will check an array, or grid, for highlighted cells and return true/false
that would be fine . .

"Ken" wrote:

Instead of using VBA to check on the cell color, wouldn't it make more
sense to build the conditional format logic into a cell formula
directly?