conditional formatting

[dimzum133]

hello,

I would like some help regarding CONDITIONAL FORMATTING

i have enclosed a photo of my worksheet for reference

What my problem is when i use two separate formula, it displays properly on the table

But after i combine them it does not show properly

Any ideas on how i can fix

btw, i am making a table for room reservation and double check for duplicate dates

 

[NARAYANK991]

Hi ,

Please upload your workbook.

Narayan

 

[dimzum133]

hi Narayan,

Thanks for helping

I have enclosed my file here

what i wanted to do is use the formula in conditional formatting to show double bookings from 2 separate list

1. confirmed bookings
2. not confirmed bookings

but my problem is if i run the formula separate it works but after i combine them and i wanted them to show only the double bookings it does not work

any help is appreciated

thanks

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[dimzum133]

hi Narayan,

Thanks for the help

i have updated the excel file, i want to have a result that shows the OVERLAPPING DATES from both list (CONFIRMED and NON CONFIRMED)

I don't understand why if i combine both the formulas i have in no1 and no2 the result should be TRUE = TRUE but its not working

The ideal result should be the chart in no3, only show the dates that have overlapped based on 2 lists

Any suggestions?

 

[NARAYANK991]

Hi ,

Did you see the file I uploaded ? The formulae in your file are the same as in the original file you uploaded first.

Narayan

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[dimzum133]

hi Narayan,

Thank you very much for the solution

I have been stuck with this formula for quite awhile now

Thanks again