# Add Cell Value To Minimum Value Of Range

• 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?

try this formula: =G9+MIN(H6:J6)

By AAE.

• 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?

[COLOR="blue"][SIZE="4"][FONT="Verdana"]AAE[/FONT][/SIZE][/COLOR]
[COLOR="blue"]----------------------------------------------------[/COLOR]

• Re: Use Color Cell In The Formula

good point AAE, here is a .xls version.

## Files

• 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)

[COLOR="blue"][SIZE="4"][FONT="Verdana"]AAE[/FONT][/SIZE][/COLOR]
[COLOR="blue"]----------------------------------------------------[/COLOR]

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!