Forum Discussion
Vehicle Management help required
Go to my OneDrive and download "USA Lottery Numbers".
My email address is on the first worksheet...
https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU
If you highlight booked autos in Red? - That would mean that autos in white cells are available? Why would green be an advantage?
Nothing Left to Lose
I could not find a file called USA Lottery Numbers among the files.
I would not be highlighting the vehicles in RED. it will be like this.
let us say- a honda civic is in cell B24.
It needs to be booked from the (1st - 10th Oct). 1st Oct is in cell K4. 2nd Oct is in cell L4. 3rd Oct is in M4.... so on and so forth till 10th Oct is in T4.
The cells i will highlight in red will be k24 to T24 (all the cells in between will be highlighted red).
So, when i click on any date between 1st and 10th oct, this particular civic should not be showing green.
Thought maybe, that you had given up. I removed the file this morning.
In the meantime, I've created a very simple example file and put it up on OneDrive.It is called "TestBookForAddingColors"
https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU
Double-click any cell in row 4 to add colors (green) - except to red colored rows.
or
Select any column cell and click the "Remove Colors" button to remove any green colors in that column.
The Green color is called "vbGreen" in VBA.
We should now have a better basis for getting what you need.
Nothing Left to Lose
- sir
pls find my file in the below link in a folder called "documents"
thank you for your time and effort
in the file you have sent, yes, you are close. but
1) the green highlight should happen on the vehicle. in columns B and C
2) the red colour does not extend to the entire row. it will be only for the dates tha vehicle is booked for
3) that green highlight is not disappearing once it is highlighted. (pls see your file. i have shared that file as well in my documents.)
once you see my file, things might be clearer
It is 5:19 am - Friday - and there is no link in your message