Page 1 of 1

Highlight entire row if two columns have certain values

PostPosted: Mon May 20, 2019 6:54 pm
by dm983
Hello guys,
So what I want to do is to be able to highlight an entire row if two conditions are met,
if values in one column have values greater than 25 and if the other column has value "no", then highlight that entire row in certain color, in the entire table (will have hundreds of rows and 10 columns)
Thanks!

Re: Highlight entire row if two columns have certain values

PostPosted: Mon May 20, 2019 10:27 pm
by Villeroy
Conditional formats are defined by formula expressions. Relative and absolute addressing takes place.
Select the range in question, say A1:X100 and notice the currently active cell, say A1, with conditions in columns M and N.
Call menu:Format>Conditional...
Condition #1, Formula is: AND($M1>25 ; $N1="no")
and choose an appropriate cell style or create one.

The mixed references $M1 and $N1 refer to the value in absolute columns M and N of this row which is the row of the currently active cell.