A
ahalford
Hi,
I have a table with the months (January - December) on the right (Column A)
and the numerical days of the month (1-31) across the top (Row 9). Cell A9
contains the year (2009)
I want to condition the format of each cell that represents a weekend day to
be yellow fill.
I have the conditional formula(s) that performs this on cell B10 as:
=WEEKDAY((DATEVALUE(CONCATENATE(A10,"/",B9,"/",A9))),1)=1
=WEEKDAY((DATEVALUE(CONCATENATE(A10,"/",B9,"/",A9))),1)=7
=WEEKDAY((DATEVALUE(CONCATENATE(A10,"/",B9,"/",A9))),1)<7>1
I am trying to replace the A in cell reference A10 with a reference of
"ROW()" to give me the month of same row as the reference cell, and then also
replace the B in cell reference B9 with a reference of "COLUMN()" to bring in
the correct data.
can anybody help, or recommend another way to arrive at the solution?
Thanks in advance
I have a table with the months (January - December) on the right (Column A)
and the numerical days of the month (1-31) across the top (Row 9). Cell A9
contains the year (2009)
I want to condition the format of each cell that represents a weekend day to
be yellow fill.
I have the conditional formula(s) that performs this on cell B10 as:
=WEEKDAY((DATEVALUE(CONCATENATE(A10,"/",B9,"/",A9))),1)=1
=WEEKDAY((DATEVALUE(CONCATENATE(A10,"/",B9,"/",A9))),1)=7
=WEEKDAY((DATEVALUE(CONCATENATE(A10,"/",B9,"/",A9))),1)<7>1
I am trying to replace the A in cell reference A10 with a reference of
"ROW()" to give me the month of same row as the reference cell, and then also
replace the B in cell reference B9 with a reference of "COLUMN()" to bring in
the correct data.
can anybody help, or recommend another way to arrive at the solution?
Thanks in advance