Nice question, but you could have test it yourself couldn't you? I did and first it looked as if it would work out fine. But at confirmation point ...
There seems to be something wrong when Excel looks at the location of your file. I tried here and when I open both files, change the formula in the Fo...
Oh sorry, must admit you're right. In all the changing and copying I must have overlooked something. Sorry. I'll look for another kind of workaroun...
Maybe it's possible Paul, see attached file (if I can upload, this is my second third attempt, it has some problems (and now I save my text for next c...
Thanks for your example file Paul. Yes with this kind of Conditional Formatting you have to make the Conditions for every Column. I don't see another ...
Hi Paul, the .xlsx didn't work here but after I changed that file in .xlsb I saw the screenshot! I'm afraid it's not possible to use relative refer...
Hi Chng.William, I see some of the issues. First: I think you are on the right way! On the 'January' tab you can skip column A now. You inser...
OK, I'll give it a try later this day (here in Netherlands) and come back to you maybe this evening.
And oh yes: I multiplied the hours with 24 so you have normal numbers.
OK, did try to give an answer but by adding the attachment my Edge 'hung'. Another try. Here what I was thinking of. I made a helper column for ...
I meant of course 'doesn't seem too difficult'
I'm working on it (doesn't seem to difficult, but always 'afraid' Sunny already presented the solution :-)). But some questions to get it more clea...
I think maybe our new member (who's name I can't read, sorry) has to make a kind of report where for every salesperson his/her maximum is visable. Can...
Catalin Bombea said Off-Topic: Hi Frank, ".........................I do understand your enthusiasm, but if we want to have a useful forum for o...
SunnyKow said "..........What Frans Visser meant was that I created a drop down list for you to choose instead of keying in................." Exa...