Highlight Date fields that are blank.

This is an optional step to take a look at and see how you like it. It does go against your initial desire of seeing the red if you're editing the record:
As long as you're using a legacy form this should work**

1. Go to a random record on your table and right click on your [Verified] field and select edit the properties of this form element
2. select your [verified] field and on the right where it says Display when this form is used for: choose view
3. now select the field named [Verified (mirror html)] and on the right where it says Display when this form is used for: choose edit or add

This way both fields won't be visible at the same time. It'll probably look better, but that will be determined by you and your desire for that form. Just throwing it out there.

I also didn't have coding experience other than SQL prior to learning and becoming an admin for Quickbase about a year ago. When I first got access to QB i created an app that only I could see and just played. I practiced adding tables, relationships, formula queries, html, coding pages, api's, everything I saw I tried to duplicate. 

I also would strongly suggest watching every one of Quickbase Junkie's videos. I attest a lot of my success and understanding as it relates to QB from her. (https://www.youtube.com/c/QuickBaseJunkie)
Discussion boards and this community are a huge help as well. I'd say just google "quickbase html formula", dig through discussions just like we're having here, try to replicate what they're saying and you'll pick it up pretty fast. Also, I constantly reference HTML, SQL, API's, Pipelines, Jinja2 all the time. I don't have much of it memorized, I just understand how and where to find the answer

------------------------------
Shane Miller
------------------------------