Attached : test_.xls
Hi,
Re: Colouring cell based on condition
Two sheets:
- Status : provides the condition for each person (holidays, etc)
- Snapshot : the report which requires updating via VBA or another means
Objective:
- The "snapshot" report in reality is quite long in the working version and takes considerable time to update each week manually. The sample provided has 5 activities.
- The "snapshot" report requires to be updated with the appropriate colours* from the "status" report.
* Happy for the colors to be changed in the solution.
Thanks in advance,
DE