Excel 2010 Copying Conditionally Formatted Cells to Another Workbook

[PWD]

Good afternoon is it possible to copy cells that are Conditionally Formatted in one workbook to another workbook AND retain the colours of the original as I'd need to use that colour to filter these results in the second workbook?

Many thanks,
D€$

 

[SkipVought]

Apparently you tried that and found that it did not.

What kind of CF criteria is it?

You could use the DisplayFormat, as I did in one of your 3-color thread, via VBA.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[PWD]

Hi Skip, yeah I thought I'd ask the specific question anyway. The CF is the one that you gave me regarding the matching diagnoses. What I think will be easier more straightforward for our staff to use will be if we copy the worksheet tab with the CF into another worksheet tab and then remove the rows that aren't formatted so that just leaves the formatted rows. From this I'm now able to use this formula:

=SUMPRODUCT((1/COUNTIF('A&E Reattendances Same'!N2:N94,'A&E Reattendances Same'!N2:N94))*('A&E Reattendances Same'!F2:F94='Weekly Activity Summary'!K4))

This will give the number of unique ID's where patients reattended the ED with a 'matching' diagnosis.

My only issue with this now is that I'd like to be able to have a variable such as COUNTA(B:B) (which does get me the last row number used) instead of the absolute "94". Just can't get this right. This isn't any good

SUMPRODUCT((1/COUNTIF(N2:"N" & COUNTA(B:B),N2:"N" & COUNTA(B:B)))*(F2:"F" & COUNTA(B:B)="29/05/2016"))

Many thanks,
D€$