Thread
:
change cell colour when cell data changes
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
change cell colour when cell data changes
Please append to threads instead of starting a new one.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Stefi" wrote in message
...
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett