happy holiday everybody! is there a function, or VBA code, that can tell the
color of a cell, given that the color is determined by conditional format?

i'm using conditional formatting to highlight when values reach beyond
accepted tolerances (i've got several columns in a sheet and near top of each
column is recommended tolerance. in cells directly below i've got values and
when a value is greater than tolerance the cell will change color ). i have
multiple sheets representing different projects, and i want to print a sheet
only when a value in the grid is highlighted.

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?

Ken


On Jul 3, 5:32 pm, mwam423 wrote:
happy holiday everybody! is there a function, or VBA code, that can tell the
color of a cell, given that the color is determined by conditional format?

i'm using conditional formatting to highlight when values reach beyond
accepted tolerances (i've got several columns in a sheet and near top of each
column is recommended tolerance. in cells directly below i've got values and
when a value is greater than tolerance the cell will change color ). i have
multiple sheets representing different projects, and i want to print a sheet
only when a value in the grid is highlighted.

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?