Highlight entire row if two columns have certain values

Discuss the spreadsheet application

Highlight entire row if two columns have certain values

Postby dm983 » Mon May 20, 2019 6:54 pm

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!
OPEN OFFICE 4.0.1., WIN 7
dm983
 
Posts: 1
Joined: Mon May 20, 2019 6:50 pm

Re: Highlight entire row if two columns have certain values

Postby Villeroy » Mon May 20, 2019 10:27 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27207
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: bbc0, MSN [Bot] and 24 guests