Conditional formatting, starting from the symbol "+"

[vittiglio]

Hi. First of all, sorry for my explanation, it might be a little bit confusing but english is not my main language and excel is a little bit specific.

So, I need to colour some of the rows in the image:

1.JPG


I need this to be colored by the following rules:
1º If it says "Remessa" the all row must be green
2º If it says "+" before the amount (VALOR) AND it starts with "T" (Descrição) the all row must be yellow
3º If it says "Depósito" the all row must be orange

So, with conditional formatting I've been able to colour the cells with the 1º and 3º rule, but only the cell itself. Is there anyway of colouring the entire row? And how can I make the 2º rule? I am a noob.

Thanks in advance!

(EXAMPLE of what I need it to look like
2.JPG

[shirleyxls]

Hi and welcome to the forum

I've created a small sample spreadsheet for you which has the rules you need using the "Formula" option. The rules are then applied to the whole area so you get the rows all coloured if one of the conditions is true.

The sample is in English - no Portuguese option on my computer Hope it give you enough to be able to adapt to your workbook.

[vittiglio]

Hello! Thank you very much for your help. It worked just fine!! :D thanks a lot!!

[shirleyxls]

My pleasure