- 22 Points
Posted 3 years ago
QuickBaseCoach App Dev./Training, Champion
-
59,768 Points
Unlike Excel there is no concept of Conditional formatting of a cell. So, you would need make a second field which is a Text formula and use that one when displaying on forms and reports.
Not tested, but try this
IF([My duration formula field]<Days(0),"<font color=red><b>")
& ToText([My duration formula field])
You will need to check the checkbox on the field properties to allow HTML.
Not tested, but try this
IF([My duration formula field]<Days(0),"<font color=red><b>")
& ToText([My duration formula field])
You will need to check the checkbox on the field properties to allow HTML.
- 22 Points
Thank you!!!
What if i add the background color the date also when it is entered?
If([Days Delivered]<Days(0), "<div style=\"background-color:red;\"> *** i want this to be the date entered not a text*** </div>", [Days Delivered] )
what should i put there? i only see the one in quickbase with the urgent is entered but the date is a big range.
What if i add the background color the date also when it is entered?
If([Days Delivered]<Days(0), "<div style=\"background-color:red;\"> *** i want this to be the date entered not a text*** </div>", [Days Delivered] )
what should i put there? i only see the one in quickbase with the urgent is entered but the date is a big range.
- 22 Points
QuickBaseCoach App Dev./Training, Champion
-
59,768 Points
Here is a help text link to background shading.
http://www.quickbase.com/user-assistance/Default.html#color_field.html
http://www.quickbase.com/user-assistance/Default.html#color_field.html
Related Categories
-
Forms
- 3202 Conversations
- 120 Followers
-
Formulas & functions
- 2834 Conversations
- 66 Followers
-
Relationships
- 2566 Conversations
- 40 Followers
-
Roles & permissions
- 2229 Conversations
- 21 Followers
-
Tables & fields
- 7102 Conversations
- 162 Followers