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.