Ask Your Question

Conditional formatting [closed]

asked 2012-10-17 02:35:09 +0200

freewheeler gravatar image

How do I conditionally format cells with a color condition, e.g if the value of a cell meets a defined condition, the contents will show in a particular color. Clicking on the conditional formatting under formats allows me to define the condition, but then asks for an Excel Style. Since I don't know which Excel Style it wants . . . .

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 16:01:46.362043


What version of LIbreOffice are you using?. From 3.6 there are new options.

m.a.riosv gravatar imagem.a.riosv ( 2012-10-17 04:28:20 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2012-10-17 07:15:09 +0200

Jean-Baptiste FAURE gravatar image

Create the style (Format > Style and Formating) you want (cell color, font, size, etc.) and choose this style in the conditional formating dialog.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2012-10-17 02:35:09 +0200

Seen: 761 times

Last updated: Oct 17 '12