Forum Discussion
Solved
incorrect formulation
Hello everyone, need a little food for thought ... or better...need your help 🙂 Examble (Cell L14) : =ODER(UND(L$9>=$C$3;L$9<=$D$3);UND(L$9>=$E$3;L$9<=$F$3); UND(L$9>=$G$3;...
NikolinoDE I didn't see any change in your conditional formatting formula. I implemented the last suggestion I made in the attached sheet and added more so it will check what day it is and auto-index down on the Jan sheet so 1 conditional formatting formula will work for every day in that month (I added the 2nd to the range and leave it to you to add the rest). You still need to tweak the formula for each category (MA1, MA2, etc...) since each needs its own color.
I also changed the formula to >= the start time but < end time because the don't actually work that hour/ half-hour period.
I also noted and corrected that your 1st 06:00am was actually 06:00am the next day and your 06:00am at the end was 05:59.999999999am (floating point error). You may want to look at the rest of the times and days for those and similar errors also.
Hi Guys,
I tried again to adapt your advice in a workbook ... but somewhere I'm messing up.
I installed the Fromel in sheet "IND1" and MA1 ... probably wrong 😞 ...
But what I want is that the shifts start from 6:00 am until the other day 6:00 am in a row as a timeline,
the time is taken from the timeline of sheet "Januar",
how could I do something with conditional formatting ?
Also attached is the worksheet
Hope I could explain well what I would like to do..
sry for the circumstances ... but as a VBA blind and Excel ignorant I want to do it somehow (somehow GOOD), the ambition grabbed me :-).
Every idea is welcome ... I'll sit down with it again tomorrow ... now my grandchild is ahead (to be visited) 🙂
Thx
Nikolino
I always know that I don't know anything ... when do I know when I know something?
NikolinoDE I didn't see any change in your conditional formatting formula. I implemented the last suggestion I made in the attached sheet and added more so it will check what day it is and auto-index down on the Jan sheet so 1 conditional formatting formula will work for every day in that month (I added the 2nd to the range and leave it to you to add the rest). You still need to tweak the formula for each category (MA1, MA2, etc...) since each needs its own color.
I also changed the formula to >= the start time but < end time because the don't actually work that hour/ half-hour period.
I also noted and corrected that your 1st 06:00am was actually 06:00am the next day and your 06:00am at the end was 05:59.999999999am (floating point error). You may want to look at the rest of the times and days for those and similar errors also.
- A big thank you to mtarler and Sergei Baklan.
Thank you for the food for thought ... is in the direction I imagined.
When it is finished I will put it here so that everyone who needs something can download it
... it will help to help 🙂
Wish everyone a wonderful good morning ... let's enjoy the day 🙂
Nikolino
I know I don't know anything (Socrates)NikolinoDE glad it helped. BTW, love your signature quote.
