I was wondering if someone might be able to help me out with something I can't manage to get my head round. I'm not sure if
this is the right to be posting this thread - I've a feeling though that the problem may only be able to be solved using
I'm creating a work scheduler in Excel 2004 - 2 linked sheets covering half a year each with a month overlap from the first
sheet to the second sheet.
The formatting of the diary elements all hang off the cell containing the first date - i.e. cell A3 = 01/01/2006.
What I'd like to do do is get all the cells in the rows directly below each date cell to look at cell A3 to get their
formatting. At the moment I have the following condition formatting to run against each cell within the schedule:
Cell Value > 0
then font colour = X and pattern colour = Y
Formula Is = OR(WEEKDAY(A3)=1, WEEKDAY(A3)=7)
then font colour = X and pattern colour = Z
Cell Value <= 0
then font colour = W and pattern colour = none
I can copy the conditional formatting horizontally without any
problem but when I try to copy vertically it screws up as the next cell down in the schedule is trying to get its formatting
from the cell A4 which has no date and results in no formatting
Bascially I need each of the cells in a column to reference the one header cell (all column A cells to reference cell A3 for
example). It would be great if the whole of the formatting for all cells could hang off the first date cell - but I expect
that is asking too much.