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 choos...
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