Excel: Is it possible to change a form color fill based on a value?

user_16911802 0
Viewed 35

I'm trying to change a form fill from my project summary based on its completion. it should look like this

enter image description here

  1. If not all itens are "OK"
  2. Form on the left is blue

If there is nothing to verify or correct it should be like this

enter image description here

I've been searching for a solution but couldn't find any, can you give a hand on this?

Thank you

dashboard excel
1 Answers

Make the bar depend on a simple boolean formula like this one:

=IF(OR(B2>0;B1>0);100;0)
=100-B7

enter image description here

Thus, if there is something in "Verify" or in "Bugs" it will be blue and if it is "0", it will be red (colors can be edited later):

enter image description here

user_54486260
Related