Custom Formula doesn't work on certain cells.
A little background, I am making a timezone sheet for a discord where someone input the time they wanted and checks who is and is not available at that time. I decided Conditional Formatting will be great for this. I used the custom formula - =IF(TIMEVALUE(na)>=N,1) - "n" being the column, "a" being the row, and "N" being the number of your time (formatted as a number).
This being interpreted as any cells in that range greater or equal than 9 pm is colored "red".
I just copy-pasted the previous formula that I implemented on the first ones. I just changed the "N" value. This is was especially strange so I deleted it then remade it. Unfortunately, still did not work. I am absolutely stumped.
this is the link so you can see for yourself.