Hello everyone!
Over the last couple of days I have been working on a Workbook for my employer. We have TV's that we use to relay pertinent information to employees. Recently they asked me to put a spreadsheet that shows all of the information that is listed week by week. They also want to know what is being removed and added per week. I was told by another forum member that this would probably be easier to do with a VBA or Macro. The current Workbook has a calendar and then an added and remove page followed by the next month.
I used conditional formatting to make information that stayed the same Green, Information that was added as Yellow, and Information that was removed in red. With help from another forum member we were able to come up with something that looks promising.
On the added removed page we made formula's to take the information and sort it based on if it was added or removed and input the value in the correct cell in the table. I believe it also links to the conditional formatting.
My issue is that the information that is populated in the tables on the added and removed page is all spaced out. I was hoping that it wouldnt have spaces in betweenMonitor Update Calendar.xlsx the information, I was told if I were to change it, it would not populate the information correctly and would also mess up the conditional formatting.
The second issue I am having is with conditional formatting. I cannot get it to work correctly. I am going to upload a copy of the current workbook that I have. Any help would b
If anyone has any advice or could help me out with finishing this project off I would greatly appreciate it! This would take a huge weight off of my shoulders to have this thing be pretty much automated.
Here is the sheet I have been working on: Monitor Update Calendar.xlsx
Bookmarks