Conditional Formating in Excel comparing dates between cells

Question

To compare the Day and Time in the cells of my two columns with one another, I use conditional formatting.

M contrasts with K, and N contrasts with L.

If the cell data is = in either situation, it should return Green. Red should be returned if >.

I've completed 45 additional data entry tasks, and up until the final row, every day and hour was flawless. Only those cells are visible on Friday. Any theories as to why this is occurring?

The row directly above it in the photographs serves as an illustration of how well the formatting is working.

Additionally, the cell formatting is dddd hh:mm.

  

I did a quick validation formula to see if N46 > L46, produce Y and it does flag as being greater for some reason. 

Answer 1

To get a date from your strings, you'll need helper columns.

You can utilize this formula, and perhaps it makes sense to develop a LAMBDA function from it (search for tutorials that address this issue). A3 represents the cell containing your data (e.g. Friday 11:30)

=LET(d,A3,
day,TEXTBEFORE(d," "),time,TEXTAFTER(d," "),
weekdays,{"Monday";"Tuesday";"Wednesday";"Thursday";"Friday";"Saturday";"Sunday"},
weekdayIndex, MATCH(day,weekdays,0), (TODAY() + (weekdayIndex-WEEKDAY(TODAY(),2) +1) ) + time)

Then you can use the helper columns for your conditional formatting. I hope this helps you.