Hello,
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!
Re: Use Color Cell In The Formula
could you post an example please?
ADDED BY ADMIN
try this formula: =G9+MIN(H6:J6)
By AAE.
Re: Use Color Cell In The Formula
its just the simple example, i have a spreadsheet with 2000 lines, so i didnt want to trouble you with so many data. http://rapidshare.com/files/247870041/example.excel.xlsx.html
Re: Use Color Cell In The Formula
thanks for the example. Is it always just one bank price per group that is coloured?
Re: Use Color Cell In The Formula
Katypoly,
It would be best, in the future, to upload or make available your workbook in Excel 97-2003 format, not .xlsx, so that more people can view it and help. Also, please update your profile since it appears you are now using Excel 2007.
Not sure I am understanding your question but, have you considered using Conditional Formatting?
Re: Use Color Cell In The Formula
good point AAE, here is a .xls version.
Re: Use Color Cell In The Formula
Thanks Dodger7 for posting .xls.
Using the workbook posted by Dogder, it seems you want to add the "winner" (lowest price) to the "forward rate".
In the attachment, try this formula: =G9+MIN(H6:J6)
Don’t have an account yet? Register yourself now and be a part of our community!
