Color coding formula Help
I am trying to create a formula to turn records that are missing a date a certain color. Here is what I have so far: If([Design Start Date]=(null),"blue") Quick Base is not stating that there ar...
Forum Discussion
if(isnull([Design Start Date]),"Blue","Other color")
Also, you can create a formula rich text and use the follow code:
if(isnull([Design Start Date]),"<CENTER><div style=\"color:white; background-color:blue;\">"& " blue" &"</div></CENTER>","<CENTER><div style=\"color:white; background-color:green;\">"& "Other Color" &"</div></CENTER>")
Or, simply you can use Color-Coding option in the report settings. All is up to you.
if(isnull([Design Start Date]),"<CENTER><div style=\"color:white; background-color:blue;\">"& " blue" &"</div></CENTER>","<CENTER><div style=\"color:white; background-color:green;\">"& "Other Color" &"</div></CENTER>")
Or, simply you can use Color-Coding option in the report settings. All is up to you.