Re: [libreoffice-users] Conditional formatting question

At 16:23 03/07/2015 +0200, Rob Jasper wrote:
> I am looking on a way to set the background color of a full row if 
> one specific field in the row has a value. [Example: C3 = 3.] I 
> looked at conditional formatting but I don't see how to format the 
> complete line based on one value in the line.

By "having a value", do you mean the specific example value of 3, or 
do you mean having value as distinct from not having a value 
(whatever that means)?

o Select the relevant rows.
o Go to Format | Conditional Formatting... .
o For Condition 1, select "Formula is" from the drop-down menu.
o In the box, enter INDIRECT("$C"&ROW())=3 - or perhaps 
INDIRECT("$C"&ROW())<>0 .
o For Cell Style, select your cell style with the appropriate 
background colour (or click New Style... and create a style on the fly).
o OK.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted