# Apply Results of Conditional Formatting to Other Cells

I'd like to apply the _results_ of conditional formatting to other cells, but not the act of conditional formatting.

I.e.:

- I have a table of correlations; below that I have a table of the p-values for each of those correlations.
- I apply conditional formatting to the lower table of p-values, making all cells with p-values less than, say, 0.01 bold.
- I would now like to apply the pattern of which cells are bold and which are not to the table above that of correlations.

If I simply apply the conditional formatting per se to the upper table of correlations, I would bold all the _very low_ (and negative) correlations, not the sufficiently large ones. Instead, I want to use the lower table to note which correlations in the upper table are sufficiently large.

As a simple example:

Upper Correlation Table

```
.9 .1
.1 .2
```

Lower Table of p-Values

```
*.001* .3
.3 .2
```

I.e., the p-value for the top-left correlation is .001, which is less than my criterion and so is made bold. I would like to copy this pattern of the top-left cell being bold and all others being not bold to the "Upper Correlation Table".

I tried copying just the formatting (Copy Special>Formatting), but this copies the conditional formatting, not just the pattern of which are bold and not.

Any ideas?

Thank you all in advance.