Conditional Format a Named range (LibreOffice)

Discuss the spreadsheet application
Post Reply
qqwasder
Posts: 4
Joined: Mon Aug 20, 2018 5:16 pm

Conditional Format a Named range (LibreOffice)

Post by qqwasder »

I named the range a1:a2 on a new and empty sheet to "JEFF" (no quotes). Then I opened Format > Conditional > Manage... > Add and entered "JEFF" (no quotes) into the Range: box at the bottom. The Range: box immediately turned Red (apparently indicating an invalid entry). Does this mean that calc does not support conditional formatting of named ranges? Thank you...
OpenOffice 4.1.5 on openSuSE 42.3
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Conditional Format a Named range

Post by Villeroy »

You are not running OpenOffice 4.1.5 on openSuSE 42.3 as indicated in your signature. What you describe fits to LibreOffice.
Named ranges work in cond. formats exactly like in formulas. Select the range where you want to apply the c. f. and use a named range in a conditional expression. The range box refers to the selection.
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
User avatar
robleyd
Moderator
Posts: 5055
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Conditional Format a Named range

Post by robleyd »

Cross posted at https://ask.libreoffice.org/t/condition ... ge/69737/2

If you cross post, please let us know that you have done so, otherwise it leads to several discussions and a waste of time because several identical answers may be posted by different users.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Conditional Format a Named range

Post by Villeroy »

Click hyperlink to select named range.
menu:Format>Conditional>Manage
The c.f. is based on the cell named JEFF
Attachments
CF_By_Name.ods
(14.2 KiB) Downloaded 102 times
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
Post Reply