I have a worksheet whose information changes constantly. We run the report weekly to create KPI's. I need to highlight the cells in the Arrival Column for everything received from 4 pm onward. I was given the formula on another post by NBVC to add to the conditional formatting -
- which works great. However, when I replace the data in my Master Worksheet, the conditional formatting formula changes and I have to keep manually changing it.
I am preparing the worksheet to be worked by other individuals who are not familiar with Excel, so I want to create a button with a macro that will do everything that needs to be done to get the spreadsheet ready. I am attaching a sample worksheet of what I am looking for. I already have a macro that Fixes the dates as the system downloads it with a leading space. I now want to create a second macro (or edit the existing macro - Fix Dates) that will go to the Main Sheet containing the data and will highlight in yellow all the Cells that contain Time that equals or is greater than 4. I have looked at other threats but cannot figure out how to apply it to my scenario.
Note that once a week, I have to delete the information on the Main Sheet and replace it with the current information. I never know the number of rows that I am going to have for any given week, but my columns are consistent.
Any suggestions or help would be much appreciated. Thank you - Monti