Ask Your Question

color scales and data bars [closed]

asked 2012-08-09 07:05:44 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

How do I crate color scales or data bars in LO 3.6? I didn't find anything.

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-17 15:56:34.356531


@tohuwawohu: Please, what's the cause for removing your informative tutorial?

manj_k gravatar imagemanj_k ( 2012-09-18 13:18:11 +0100 )edit

See also: moggi's blog about Libreoffice hackingColor scales and data bars

manj_k gravatar imagemanj_k ( 2012-09-18 13:22:36 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2012-10-03 14:35:23 +0100

Mohith gravatar image
  1. Select the range of cells you want to apply color scale or data bar.
  2. Pick conditional formatting from Format menu.
  3. Click on Add button
  4. From the first list, select 'All cells'.
  5. From the second list, pick color scale or data bar Rest should be easy to figure out..

By the way, you'll need LO 3.6 or above.

edit flag offensive delete link more

Question Tools


Asked: 2012-08-09 07:05:44 +0100

Seen: 8,996 times

Last updated: Oct 03 '12