I'm looking for a macro that can change the cell fill color according to a value in an adjacent column every time the cell is changed.
I have a Column A which contains values (calculated by formula). In Column B i have sorted the rows into groups (Group A, Group B, Group C etc). I would like to have the fill color in Column A change according to the value in Column B everytime the value is changed in Column A. Typically Group A gives a green cell fill, Group B a red fill and so on...
I cannot use the conditional formatting functionality in Excel 2010 due to the limitations when the file is opened in Excel 2003.
All help greatly appreciated :)