Paint cell with conditional formatting using SE

Asked

Viewed 7,024 times

0

I wanted to know how to paint the cell phone of a certain value:

For example: I have a salary of R$100,00 in cell A1 In cell B2 goes the sum of my accounts So in cell C1 I would like to paint red if the bills went over $ 100,00 and green if it does not pass.

Formatação Condicional

excel

1 answer

1


Use conditional formatting option:

Passo1

Passo2

Passo3

inserir a descrição da imagem aqui

To paint green use another format condition with the "Larger Than" and ask to paint green.

  • Rodolpho understood what you meant. But I need this all in the same cell. I will edit my question and put the example image there

  • Edited, I put the image for better understanding.

  • @Arthur You can use two conditional formatting in the same cell. One "It’s Bigger than..." and another "It’s Smaller than..." and one will paint green and the other red.

  • 1

    Ah, I get it. I didn’t know that. I thought one subscribes to the other. Closed then. I did it here and it worked. Thanks man.

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.