Forum Discussion
MarkShnier__You
5 years agoQrew Legend
Unlike Excel, you cannot directly apply Conditional Formatting to a cell. But you may create a Rick text formula field.
This is not tested but try this. if there is a syntax error, please post your code and the error.
var date DueDate = [your date field goes here]; //this is a formula variable so it needs to end in a semi colon.
IF($DueDate <= Today(), "<font color=red><b>")
& ToText($DueDate))
// The date will appear in the numerical format MM-DD-YYYY
If you prefer to see it where the Month is in Words, like JAN, post back and I have a formula for that.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
This is not tested but try this. if there is a syntax error, please post your code and the error.
var date DueDate = [your date field goes here]; //this is a formula variable so it needs to end in a semi colon.
IF($DueDate <= Today(), "<font color=red><b>")
& ToText($DueDate))
// The date will appear in the numerical format MM-DD-YYYY
If you prefer to see it where the Month is in Words, like JAN, post back and I have a formula for that.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------