Formula Code Help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Toby Lunt (ybot_85_at_prodigy.net)
Date: 03/21/04 

Date: Sun, 21 Mar 2004 13:51:11 -0800

Hi,

I'm working on a spreadsheet that contrasts the pricing of different products from different suppliers, as follows:

               Supplier A Supplier B Supplier C
Product X $50 $40 $30
Product Y $30 $40 $50

Etc. What i have been trying to do through conditional formatting is to highlight the cell with the lowest price for each product. However, I dont know how to write the formula so that I can fill down for each row, because conditional formatting only allows me to refer to each specific cell, thus I have to do the same conditional format 80 times for 80 different rows. I just need to know the syntax for the code to write the formula. Thanks!

Toby

Relevant Pages