Hi all,
I have a document where each supplier is entering their price, I have copied these documents into 1 TAB for each supplier and I want to be able to identify which is the supplier with the cheapest price. i though it was best to highlight a colour from each TAB. The document I am actually working off is over 50 columns wide and 200 rows deep. On the front tab is a formula to show the min price which but this is where I also want it to highlight the lowest price from the TAB.
The highlight is to be a specific color for each supplier
Sorry tried to work out where to attach a document but can not see
ta
Jezza
I have a document where each supplier is entering their price, I have copied these documents into 1 TAB for each supplier and I want to be able to identify which is the supplier with the cheapest price. i though it was best to highlight a colour from each TAB. The document I am actually working off is over 50 columns wide and 200 rows deep. On the front tab is a formula to show the min price which but this is where I also want it to highlight the lowest price from the TAB.
The highlight is to be a specific color for each supplier
Sorry tried to work out where to attach a document but can not see
ta
Jezza