Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a work schedule that is 365 columns wide - all very narrow so that 2
or 3 months fits onto the screen at a time. Row 1 is the month name, with each month a "merged and centered" cell spanning the 30 or 31 cells for that month. Row 2 is the "day of month" number (1,2,3...30,31,1,2,3...etc). Row 3 through whatever (currently 22) is for the employee... each cell indicates what the employee is doing that day (on duty, on vacation, etc.). I'd like to format rows 2 and below so that the current day is highlighted yellow. So, on Jan 20, T2:T22 would be yellow. Today (April 5th) would have CQ2:CQ22 highlighted. I am having problems with the "merged cell" part of the formula, I think. Thanks, Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formula based on dates | Excel Worksheet Functions | |||
PLS HELP - Conditional Format w/Dates | Excel Discussion (Misc queries) | |||
Conditional Format with dates | Excel Discussion (Misc queries) | |||
CONDITIONAL FORMAT BASED ON 2 CELLS | Excel Worksheet Functions | |||
Conditional Sum based on Bold Format | Excel Discussion (Misc queries) |