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!
Highlight entire row if two columns have certain values
Highlight entire row if two columns have certain values
OPEN OFFICE 4.0.1., WIN 7
Re: Highlight entire row if two columns have certain values
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.
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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice