| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check date range on three sheets?
How can I get a date to turn red if it falls within a date range in two other
sheets. ie: Leave dates for three person are inserted in their own sheets. If one of them chooses to have leave dates that conflicts with another, is there a way if the date to turn red? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check date range on three sheets?
Assume that leave start dates are in A2,
end dates in B2, then select range A2:B2 on sheet of person 1, name this range leave1, do the same with sheet of person 2, range name leave2, and apply conditional formatting on date on sheet of person 3 with this formula: =OR(AND(A2=INDEX(leave1,1,1),A2<=INDEX(leave1,1,2 )),AND(A2=INDEX(leave2,1,1),A2<=INDEX(leave2,1,2) )) Regards, Stefi €˛Geo€¯ ezt Ć*rta: How can I get a date to turn red if it falls within a date range in two other sheets. ie: Leave dates for three person are inserted in their own sheets. If one of them chooses to have leave dates that conflicts with another, is there a way if the date to turn red? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to check if a date falls within a range(2 cells: Start/End Dat | Excel Worksheet Functions | |||
| Check Date Range and Multiply Stock Qty | Excel Worksheet Functions | |||
| check whether a date falls in a range | Excel Discussion (Misc queries) | |||
| how to check if date falls within range | Excel Worksheet Functions | |||
| Can I check if a date falls between a range then sum other # if tr | Excel Worksheet Functions | |||
Hybrid Mode
