I need a cell to have the same colour as another cell if it's greater than 0.
A1 = 200 and is colour green
B1, C1, D1, E1, F1, could equal the 200 (say D1 for this example as it moves to a different cell dependent on the date). The rest would equal 0. I need the cell that the number is in to colour the same as A1 in this example green.
However B2 = 300 and could be yellow, in this line E2 = 300
C3 = 400 and is Orange in this line it's B3 = 400
I have 6 colours in all, and as you can imagine that having to reformat over 400 lines when the date changes and the cells all move along but the colour doesn't is quite a pain.
Any help would be appreciated.