print macro dependent on conditional format

M

mwam423

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?
 
M

mwam423

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional format question 2
Conditional Formatting with VBA 4
conditional format fails when copied 1
Referencing conditional format is another workbookHI 7
A Huge Conditional Format Challenge.... 2
macro alternate conditional format change 0
Format change with VBA language dependent? 5
Excel 2003 : conditional format for 5 format settings 1

Top