View original (French)

Select all rows containing a word

Solved
shevonna Posted messages 2 Registration date   Status Member Last intervention   -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello,

I'm sorry, I'm new and maybe not very good, but I had a question.

I have a spreadsheet that looks like this:

Date !! Time !! "out" (or "in") !! message

I would like to know how to select all the rows that contain "out" or "in" in the third column to change the font color for one of them and the other for a different color.

I just want to not change "out" or "in" to a color, but the entire rows that contain them.

Knowing that I have a HUGE number of rows, I would like not to do it row by row...

Thanks in advance!

5 answers

Answer 1 / 5
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
 
Good morning
assuming your column that contains out or in is column C, starting from row 2 (to be adjusted)
select the entire field, from A2 to xxxx (?)
Ribbon / Home tab / Conditional Formatting / New Rule
in the window: "use a formula ....)
next window, enter the formula:
=$C2="in"
(pay attention to the $ sign which allows covering the entire row of the field
click on format / format as desired / click OK and you return to the CF window
/ New window:
the formula:
=$C2="out"
format / format / and OK / OK

best regards

--
To err is human, to persist is diabolical.
8