[Solved] Highlight MIN/MAX values with cond. formatting

Discuss the spreadsheet application

[Solved] Highlight MIN/MAX values with cond. formatting

Postby AndrewRi » Fri Jan 03, 2020 1:05 am

I'm having trouble with conditional formatting in a spreadsheet. I want the MIN value in select, nonadjacent cells to have a highlight background one color and Max value a different color. I thought I understood this and I almost have what I want, but the spreadsheet does not seem to recognize that I want the conditional formatting to only be the cells I designate. As it is now the cells adjacent to the specified cells are also conditionally formatted. Here is my input "$BK3:$CI3=MAX($BK3;$BQ3;$BW3;$CC3;$CI3)". What am I doing wrong?
Last edited by AndrewRi on Wed Jan 08, 2020 6:43 pm, edited 2 times in total.
OpenOffice 4.1.6 on Windows 7
AndrewRi
 
Posts: 5
Joined: Fri Aug 09, 2019 10:56 pm

Re: Conditional formatting

Postby Villeroy » Fri Jan 03, 2020 1:34 am

Select the range you want to format conditionally.
Notice the active cell within the selection. Let's say it is BK3.
Call the conditional formatting dialog. It applies to the active cell only, copying the settings to the whole selection.
Choose a cell style and "Formula Is:" $BK3=MAX($BK3;$BQ3;$BW3;$CC3;$CI3)
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.4
User avatar
Villeroy
Volunteer
 
Posts: 28824
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Conditional formatting

Postby AndrewRi » Fri Jan 03, 2020 3:49 pm

That didn't work for me. It conditionally formatted every cell in the line. I'm using OpenOffice 4.1.7 and Windows 10.
OpenOffice 4.1.6 on Windows 7
AndrewRi
 
Posts: 5
Joined: Fri Aug 09, 2019 10:56 pm

Re: Conditional formatting

Postby Villeroy » Fri Jan 03, 2020 5:05 pm

Works for me
Attachments
CF_100613.ods
(23.05 KiB) Downloaded 33 times
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.4
User avatar
Villeroy
Volunteer
 
Posts: 28824
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Conditional formatting

Postby Villeroy » Fri Jan 03, 2020 6:52 pm

In order to expand this cond. format, select the range in question with the active cell having the c.f. Call the dialog and hit OK.
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.4
User avatar
Villeroy
Volunteer
 
Posts: 28824
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 19 guests