View original (French)

Libre Office Calc conditional formatting for days

Solved
nicoweb61 Posted messages 280 Status Member -  
nicoweb61 Posted messages 280 Status Member -

Hello everyone,

In LibreOffice Calc, I have set up a calendar with dates and days automatically.

That said, I am looking to implement automatic formatting for the cells in the columns corresponding to the weekend.

5 answers

  1.
    yclik Posted messages 70 Registration date   Status Member Last intervention   1 609
     

    Good evening

    To test

    Select B5 to AF30 and conditional formatting as below

    1
    1. nicoweb61 Posted messages 280 Status Member 19
       

      Thank you so much!

      0
  2. brucine Posted messages 24813 Registration date   Status Member Last intervention   4 165
     

    Hello,

    I use Excel, but the syntax is essentially the same; you create a condition applied to all cells according to the formula =OR(WEEKDAY(cell)=1, WEEKDAY(cell)=7) with the desired color format, fill...

    0
  3. nicoweb61 Posted messages 280 Status Member 19
     

    Unfortunately, I can't manage to do what it takes for the cells below to appear in the right color for the weekends.

    I'm looking for a simple tutorial for formatting these...

    0
    1. miguelpineau Posted messages 175 Status Member 13
       

      What are you going to enter in the cells? A letter? Or is it filled with a specific color?

      I see a "2023" sheet in your screenshot in addition to the table. I'm thinking that if I had a project to include absences and vacations, I would enter dates so that it automatically colors the table using IF(), T(), and style() functions like a Gantt chart (video).

      0
  4. miguelpineau Posted messages 175 Status Member 13
     

    Hello,
    With the T(Style()) function, here is an example of videos with the Gantt chart:
    https://www.youtube.com/watch?v=9F57X7IkGC8&feature=youtu.be

    0
  6. miguelpineau Posted messages 175 Status Member 13
     

    Hello,

    I have created a leave entry file where the input is restricted.
    The table is protected from any modifications.

    You can watch my presentation video:

    https://www.youtube.com/watch?v=Moti_JbB9bg&feature=youtu.be

    The file is available on my website.

    Best regards,

    Miguel Pineau

    0