View original (French)

If color of the box...

Ptio94 Posted messages 27 Status Member -  
Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   -
Hello.

I manage several employees (actually a very large number) and I would greatly like to simplify my life regarding their schedules;

I plan to create a formula that will immediately remove them from their schedule if they are marked absent in mine.

The thing is, when they're on the morning shift, their cell color is white, and when they're on the evening shift, their cell is blue.

I would like to find a formula that takes this parameter into account, that is to say "if the cell color is white; condition if true; condition if false).

Even if this is not exactly how the formula should exist, I am ready to adapt ;)

I tried using the formula =NO_COLOR, without success.

If there is a savior here, I would be more than grateful for help in making my life easier :D

Have a good day and good luck in these challenging times.

3 answers

  1.
    Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 494
     


    Hello.

    " I tried with the formula =NO_COULEUR, without success. "

    This formula does not exist, nor does the function of the same name!

    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0
    1. Ptio94 Posted messages 27 Status Member
       
      My bad, it was the formula "color".
      If we input the color values of a cell (RGBA), I think we can combine it with an "if".
      But the fact is that I don't know how to find the "alpha" color of a cell. (for the RGB I see it in the cell format but for the alpha I haven't found it).
      0
  2. Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 494
     
    You insist a lot, but unfortunately:
    • There is no COLOR formula
    • There is no COLOR function
    • You cannot use a color number (or code) to write a formula or launch a search.

    The correct approach is to apply the fill colors of the cells in the schedule using the rules of Conditional Formatting: you type R in a cell, it turns red; you type V, it turns green.
    Your problem is solved: you use these codes R, V, etc. in your formula!

    --
    Retirement is great! Especially in the Antilles...
    Raymond (INSA, AFPA)
    0
    1. Ptio94 Posted messages 27 Status Member
       
      Sorry to be insistent as you say, but the function does indeed exist.
      LibreOffice Calc:

      0
      1. Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 494 > Ptio94 Posted messages 27 Status Member
         
        You are right: all my answers were based on Excel, not on Calc ...

        So I looked into Libre Office, but I still haven't figured out how to use this function!
        0
  3. yclik Posted messages 3883 Registration date   Status Member Last intervention   1 613
     
    Hello
    Is it perhaps an extension?
    0