Hello All,
Is there a way of setting up a spreadsheet so that the 'colour scales' available in 2007 will apply to each row at a time. I can go through each row one by one and format them manually to show the highest and lowest price in that row. However as soon as I try and auotomate the process or drag the formatting down the page it incorporates the prices on other rows which I want to avoid. It will make more sense if you look at the attachment.
Thanks
gareth
Bookmarks