Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting the ROW() command into a Conditional Format Formula
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)<71 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 -- Regards, Andy Halford |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional format formula | Excel Discussion (Misc queries) | |||
Conditional Format & Formula | Excel Worksheet Functions | |||
nesting conditional formulas | Excel Worksheet Functions | |||
Nesting IF statements, Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional format with a formula | Excel Worksheet Functions |