I have a spreadsheet which i use record my daily profit and Loss (Daily PL) i have
the 365 days of the year in column A descending. At the end of the year i collate the final numbers and these are stored on another worksheet (Totals) in weekly and monthly form this worksheet has several years of this data.
What i'm hoping to do is conditionally format the Daily PL worksheet. So each group of 7 days have a background fill colour depending on previous year performance (which i derive from the Totals worksheet).
I have managed to do this for the First week but the question is do i need to create a new rule for each week?
the 365 days of the year in column A descending. At the end of the year i collate the final numbers and these are stored on another worksheet (Totals) in weekly and monthly form this worksheet has several years of this data.
What i'm hoping to do is conditionally format the Daily PL worksheet. So each group of 7 days have a background fill colour depending on previous year performance (which i derive from the Totals worksheet).
I have managed to do this for the First week but the question is do i need to create a new rule for each week?
