June 26, 2016
Hello to all my name I am Maurizio and I am a New Member.
My problem with this using excel office 2007 I created a perpetual calendar using a userform.
Now I have to admit that: Everything works fine, except for one fact that I can with all my good will to solve.
And my problem is this: I would that changing the date is in Txt.Anno TXTMese in which the number of the current month of Yellow colorasse opening dell'userform.
Some of you would know me out about Thanks.
Sincere greetings from A.Maurizio
New Member
June 27, 2016
Why not try something like the sheet I have attached. I set up two cells with =NOW() and =NOW()+1 and then conditionally formatted the range of cells I wanted to use to highlight cells in yellow who's value is between the two =NOW cells. I had to do that because =NOW() runs to the microsecond so a straight if A=B then wouldn't work.
Have a look a see what it looks like.
1 Guest(s)