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?
|