Forum Discussion
naturalgaswizard
Dec 30, 2024Copper Contributor
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...
Patrick2788
Dec 30, 2024Silver Contributor
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.