Check date range on three sheets?

  • Thread starter Thread starter Geo
  • Start date Start date
G

Geo

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?
 
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:
 
Back
Top