Does anyone know if a large bold red text can display at the top of an Account record based on critieria like "Overdue Account" or "Past Due" or "Need to buy Contract"?
Yes. Easily done if you are using lightning. Go to the Account record page layout > Edit the Lightning Page layout > Add a rich text lightning component > Set Component visibility > Filter based on your criteria Let me know if you need further assistance.
Yup, conditional rich-text components are a great option, if using Lightning EX. If you are using Classic and/or want an option for your users using the mobile app, you can create a formula field (i.e. Account_Standing__c), that has a CASE or IF statement checking to see if your other field matches any of those criteria, then display an image with the words/graphic you want to show to get their attention.
Go to the Account record page layout > Edit the Lightning Page layout > Add a rich text lightning component > Set Component visibility > Filter based on your criteria
Let me know if you need further assistance.
https://help.salesforce.com/articleView?id=useful_advanced_formulas_image_links.htm&type=5