Conditional Formatting - Using another cell to specify the colour??

Hi all,

This could be completely impossible, but is there any way to make a cell turn the same colour as another cell once a figure higher than 0 is entered?
Basically in column A I have various activity descriptions, each cell with a different colour (i.e. A1 is coloured blue, A2 is coloured red, etc). From column B onwards the user is able to enter a numerical value, and if the value is above 0 that cell will then change to the same colour as the cell in column A (so if the user entered '1' in D1 it'd turn blue, etc). At the moment I just have a conditional format that has the colour specified on each line, but I want to give the user the opportunity to add new activities or change the colours if they wish, so I'd love to have something in place that allows that). I'm guessing that even if this is possible it'd be a macro rather than a conditional format?

Thank you!

Sorry, I thought it would be better in the VBA section rather than the Formatting section of the forum. I wanted to close the other one but it's already been closed for me!