Printing based on Conditional Formatting!

[mellowe]

Hi All

Is it possible to have a macro be able to print based on conditional
formatting?

I have a base sheet that has several cells with buttons on so that when
a certain button is selected you are directed to the sheet required.
The cells above the buttons have conditional formatting so are colour
coded - Amber, Green and Red.

What I need is when a macro to identify when a cell is Red - and to
print the referenced sheet ... not sure if this is possible but any
help would be greatly appreciated.

Thanks!

 

[Norman Jones]

Hi Mellowe,

Have the macro evaluate the conditional format condition which corresponds
to red.

 

[mellowe]

Thanks Norman for the reply but I am not sure how you can get a macro
to check a conditional format...are you able to assist? Thanks!

 

[mellowe]

I think I need something that says:

=If conditional cell format is Red then print sheet 1 and print sheet
3.

Just not sure of the formula to use?!

There is a formula in the Cells with conditional formatting that
populates the cell with Red, Amber, Green or 'false'. Then if the cell
is 'Red' print sheets..., if cell is 'Amber' then print sheets....

 

[Norman Jones]

Hi Mellowe,

Thanks Norman for the reply but I am not sure how you can get a macro
to check a conditional format...are you able to assist? Thanks!

Suppose, for example that the range of interest has conditional formatting
applied using the CF formula:

=A1>10

to display range cells in red. In such a case, the simplest solution to your
problem is to test the formula, i.e. if A1 contains a value > 10, then the
cells of interest will be diplayed as red by virtue of the applied CF.