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?

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?