One way using CF:
Create a background copy of the worksheet at each refreshment and apply CF
with this formula:
=A1<background!A1

Regards,
Stefi

€žBec G (Oz)€� ezt Ã*rta:

Hi

I've built a resource planning spreadsheet that is populated by macros. In
each month (in columns) it populates with 1 if there is a person in the
position or may be blank or 0 if the position is vacant. The spreadsheet goes
out to 2014 monthly. The 12 months of each year are colour coded as one
colour. I have been asked to have the cell colour change if the user changes
the value of the cell.

The spreadsheet will be periodically refreshed by the macro and saved as a
new version so the orginal colours need to be reinstated with and changes
then causing the cell to be changed.

I can't get it to work with conditional formatting, any suggestions?