Formatting to change Color and Status depending on Conditional of another cell [closed]

Navigation
1
VALOR= A/B      0   1   PERIGOSO
                2   3   POBRE
IA= A (400)/    3   4   QUESTIONÁVEL
    70          5   6   CONFIÁVEL
    5,71        7   8   BOM
                >   9   EXCELENTE

I want to automate a worksheet to get the result of the division that would automatically select the "BOM" cell, the value being between 5 to 6 for example, in the condition SE I can not get the result. How do I solve this problem?

Thanks for the help

    
asked by anonymous 31.10.2017 / 19:40

1 answer

1

You can use conditional formatting to format the colors of these two cells based on values.

Conditional Formatting

Open conditional formatting

Select the two cells that will be filled with color, with the value and the result (Good, excellent, etc.)

Open Formatação Condicional > Nova Regra > Usar uma fórmula para determinar quais células devem ser formatadas

Format by formula

In the Formatar valores em que esta fórmula é verdadeira field, enter the range of values in which the formula will fill the color, for example:

  • For values between 5 and 6:% with%
  • For values between 6 and 7:% with%
  • And so on ...

Choose color format

In the field of =E($A$5>=5;$A$5<6) > click =E($A$5>=6;$A$5<7)

A window will open and the Visualização tab should be selected. In this tab, choose the fill color for the formula values.

Formatting should look like this:

Tochecktheformattingandedit,gotoFormatar...>Preenchimento

SelectFormataçãoCondicionalinGerenciarRegras...,whereformattingshouldlooklikethis:

Statusvalue

Tochangethevalueofthetable,thefollowingformulamustbepopulatedwiththeconditionalvaluesforfacestatus.

EstaPlanilha

Inordertoaddothervalues,simplyinsertMostrarregrasdeformataçãopara:into=SES(E($A$5>=4;$A$5<5);"QUESTIONÁVEL";E($A$5>=5;$A$5<6);"BOM")

Result

    
01.11.2017 / 12:04
Working with Data in ngInit How to return integer value in pthread?