colour scales conditional formatting

Hi,

I am hoping someone can help as this is driving me up the wall and their must be a simple solution to it.

basically i have 200 rows each with different customer names. i then have columns respresenting week numbers with their sales in each cell.

I would like to apply a colour scale to each row which has green as the highest number and red as the lowest. i can do this for one row. thats simple. However when i highlight the entire range of cells and add the colour scale, it does not base the colour scale on each individual row.

Does anyone know how to solve this problem?

thanks

Hi and welcome to the board
Maybe post a small sample of your data wit an example of what you need to echieve?