Forum Discussion
Conditional Formatting
Hi guys! I have statistical model results in 8 rows across columns E-H for 8 years of data. I have applied conditional formatting to select the greatest r-squared and the greatest top 30 r-squared. I have also applied conditional formatting to select the least greatest standard errors. I would like to paste those conditional formatted results in empty cells below the years of data. How do I achieve this?
2 Replies
Presumably, your data has already calculated the R-squared value where needed and we're simply identifying the greatest r-squared, if top-30, etc?
What were you looking to show in the sheet for the results? Essentially, conditional formatting results are TRUE or a number where criteria is met. A sample workbook might help.
Assuming I've understood your desire
- Select the range(s) to be copied,
- Select "Copy" or Ctrl-C
- Select Paste Special and select "Values and Formats"
