If color of the box...
Ptio94
Posted messages
27
Status
Member
-
Raymond PENTIER Posted messages 58207 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58207 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.
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
You insist a lot, but unfortunately:
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)
- 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)
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).