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: [email protected]
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
