Forum Discussion
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 choosing. The issue is that I want this done automatically and it's difficult because the highlighted cell could be in any cell in the chart depending on the data sheet I import. Thanks for your help!
3 Replies
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.
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.
Most probably it could be done by formulas, but based conditional formatting logic, not on colors
