Ask Your Question
0

Advanced Conditional Formatting with Date

asked 2017-04-02 14:05:01 +0200

creativeflower gravatar image

updated 2017-04-02 14:05:57 +0200

I am playing around with libreoffice and like it. Now I am faced with conditional formatting each row:

  • In each row is a date including the days of one month - bu not necessarily all days of the month are included
  • I would like to deploy a color gradient from the earliest day of the month to the latest day of the month
  • the color could be from white over gray shades to black - and from black to dark green to light green (for more shades and better contrast) How to achieve this per row?

    I added example rows below:

03/01/17    03/02/17    03/03/17    03/04/17    03/05/17    03/06/17    03/07/17    03/31/17    
04/01/17    04/02/17    04/03/17    04/19/17    04/30/17    04/06/17    04/07/17    04/30/17
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2017-04-02 15:48:42 +0200

karolus gravatar image

Hallo
Select each row individual and choose
→Format→Conditional Formatting→Color Scale …(your Settings)…→ok

edit flag offensive delete link more

Comments

likey likey :D

creativeflower gravatar imagecreativeflower ( 2017-04-06 19:32:04 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-04-02 14:05:01 +0200

Seen: 163 times

Last updated: Apr 02 '17