a have a question:
if I have cell A1 that contains formula but in cell range A2:A9 I have different numbers.
I need to use in my formula a number that have a collorful cell. Can anybody pls help with VBA code or just excel?
I will explain why i need it. There are prices from different banks, but into calculation i need to take a price of a winner, and the price of a winner has a colourful cell.
Thank you for any suggestions!