Can I change a cell background based on yes or no answer. I have multiple yes/no answers in my report and want the yes's as green cells and no's as red.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Can I change a cell background based on yes or no answer.

I have multiple yes/no answers in my report and want the yes's as green cells and no's as red

For each row there are multiple yes or no answers and I want each cell to respond colour wise individually.

Photo of Ruth

Ruth

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
There is no function in QuickBase for cell conditional formatting like how excel works.  So you will need to create a new "mirror" field for each yes/ no field and apply a formula to that new field to apply the background shading.

Here is a Help topic on how to do that.

http://help.quickbase.com/user-assistance/Default.html#color_field.html
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
You can do this with script. See screenshot of manually applying the following script through the console:

$("span.uncheckedBox").closest("td").css("background-color", "rgb(255,0,0)");

$("img[src*='checkmark_20.png']").closest("td").css("background-color", "rgb(0,255,0)");