Hello,
In the attached file I would like to have dates appear, or marked with a color print automatically in the calendar page under each chalet reserved when they are entered in the dAta base called InfoReservation page .
Is this possible to create a formula witrhout using macro or VBA?
Thnak you
Ley me know if you have any other questions
Hello.
Are you still using Excel 2007?
I'm not sure all functions I use are available in Excel 2007, but I will give it a shot.
Select the range C9:AG28.
In Conditional Formatting, select New rule,
Then select "Use a formula to determine which cells must be formatted".
Then, to highlight the cells matching date debut and chalet, use this formula in the box "Format values in which this formula is true":
Formula:
Please Login or Register to view this content.
Select formatting as desired and finish.
I hope this helps you.
Good luck!
Yes I do see it and can use it, but what I would like it to do is print the color on all the total of the days , even when its in 2 different months, so for example if the reservation is for 7 days , then there would be 7 cellule highlited.
Is this possible?
Ohh yes and also I am receiving a ponctuation mistake in the formula, my excel is in english
Administrative Note:
Is your forum profile showing the Excel PRODUCT that you need this to work for?
Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.
The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.
Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hello thank you for the feed back, so yes I am using microsoft 365 , not excel 2007.
I am still having isues with the formula it always sends back mistake in the formula but doesnt say what the mistake is.
Thank you for your help.
Pascale
What 'mistake'? It must say something.
The formula is working in the attachment to post #2 - did you open that? You should copy the formula from the workbook, NOT the post.
Attach a sample workbook with the 'problem' showing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks