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 a summary sheet which
lists each project. i want to print the summary each period and print a
project sheet
only when a value in it's grid is highlighted, i.e., there is tolerance issue.

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

See Chip Pearson's site.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP

On Thu, 5 Jul 2007 13:28:01 -0700, mwam423
wrote:

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 a summary sheet which
lists each project. i want to print the summary each period and print a
project sheet
only when a value in it's grid is highlighted, i.e., there is tolerance issue.

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

hi gord, appreciate the response. took a look at the site and have question
(i'm hoping you might know answer), can =ColorIndexofCF, or =ColorofCF be
applied to a range?

"Gord Dibben" wrote:

See Chip Pearson's site.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP

No. One cell only.

The countof and sumby take ranges.

Gord

On Thu, 5 Jul 2007 16:12:03 -0700, mwam423
wrote:

hi gord, appreciate the response. took a look at the site and have question
(i'm hoping you might know answer), can =ColorIndexofCF, or =ColorofCF be
applied to a range?

"Gord Dibben" wrote:

See Chip Pearson's site.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP

hi gord, sumby does the trick, thanks again for your help!


"Gord Dibben" wrote:

No. One cell only.

The countof and sumby take ranges.

Gord