highlighting where the minimum value falls in

**NY_BOY** · 04-30-2009, 10:38 AM

I have attached the excel document for your view.

I got a problem. I have selected two fields that shows the minimum price. As you can see on the attachment, fields G2 and G3 are the minimum value. My question is this. Being that G2 and G3 display the minimum values, how can I write a formula that based on whatever is the minimum value, that minimum value will be highlighted where ever it shows on the table?

Table as in: C2:F3

Your help will be greatly appreciated.

**martindwilson** · 04-30-2009, 10:44 AM

use conditional format
highlight c2:f2 and use formula is =c2=MIN($C$2:$F$2)

**NY_BOY** · 04-30-2009, 02:29 PM

Thank you so much for your collaboration. However, I tried in putting that code: =c2=MIN($C$2:$F$2) on G2 and it gave me an error, it says 'FALSE'.

Whoever can help me I will really appreciate it.

**martindwilson** · 04-30-2009, 07:14 PM

you wanted it to highlite cell ,you need to use conditional formatting you dont put the value in the cell
see here its to long winded to explain how its done in 2007
http://www.accountingweb.co.uk/cgi-b...&h=1033&f=1026