change cell colour when cell data changes
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?
|