Dear all,
I need your help here...i have some apartments that i am renting.
When i insert a name in a room number with arrival and departure date (DATA SHEET), i need to be auto copied on the specific room with color and according the dates (RACK).
I want it in order to know the departures of each day.
Attached the example.
Thank you all in advance
The shading is relatively easy. However, shading in different colours is not. I think you will need VBA to achieve this.
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.
In cell C2 in Rack worksheet insert the formula below and press CTRL+SHIFT+ ENTER
Formula:
Please Login or Register to view this content.
As a conditional formatting rule you can use the formula:
and choose format you like.Formula:Please Login or Register to view this content.
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks