Forum Discussion
ExcelNoob747
Oct 23, 2020Copper Contributor
Which Formula to use to Select a Highlighted cell
Hi, So I have a complicated chart that is currently highlighting (using conditional formatting) a single cell with my desired value. I would like to display this value onto another cell of my choos...
SergeiBaklan
Oct 23, 2020Diamond Contributor
I guess you use some conditional formatting rule formula to highlight the cell, you may use the same logic to return value of such cell.
Pick-up the value based on color returned by conditional formatting that is VBA programming. You may find the discussion about that with code here, that is quite long thread with many pages and with the sample of VBA code. I don't have direct link.
ExcelNoob747
Oct 23, 2020Copper Contributor
SergeiBaklan Thank you for that! I was hoping to avoid using VBA as I'm not too familiar with code but I suppose I will have to give it a shot! Thanks again.
- SergeiBaklanOct 23, 2020Diamond Contributor
Most probably it could be done by formulas, but based conditional formatting logic, not on colors