conditional format question
 

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.

conditional format question
 

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.

conditional format question
 

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?