Conditional formatting not recognizing date from Asian user

I have a form which my counterparts in Asia - Mostly China, Taiwan, and Vietnam - are completing for me. This form includes a lot of conditional formatting to ensure the form is completed correctly. This includes a check to make sure the quote date is entered and in the correct format. The problem is the form doesn't recognize the date as being entered correctly so the conditional formatting is wrong.

The desired outcome is for the cell background to be yellow until a date is entered into the cell, then the cell turns to white.

In the example I provided, the cell has a value of '8/13/2024', which should display as '08/13/24' due to the text formatting, however the cell treats the value as text and the conditional formatting check is false so the cell stays yellow. I have been unable to recreate the issue on my end: for example, if I cut the cell contents and paste them back, the cell recognizes the date, displays '08/13/24', and turns white.

Rules I have tried:
"cells that contain" using a value between 1 and 54789
=ISNUMBER(DATEVALUE($B$1))
=ISNUMBER($B$1)
However, I think it's a problem with how Excel localizes the date input so the form doesn't properly recognize it and I have no idea how to compensate.

Thank you for your response Ali: if that it the case, why does the file convert it to m/dd/yyyy (recognizing the format needs to change) but still treats it as text? (Doesn't fully change the format)

Also, I'm still not able to recreate the issue to test if your solution would work. Any thoughts?
I would hope to avoid having to wait days for results and continue using a form which is potentially still not working correctly.