TypeScript Expert Needed for Excel Formatting -- 2
Budget: $30 – $250 USD
If this is possible: Two scripts to run on Excel file located on SharePoint (cannot use VB). They should run on opening of the file or with the push of a button. NOTE: I cannot provide you access to a SharePoint file, you will need to be able to test this on your own. I can send you a sample Excel desktop file but you will need your own means of testing on SharePoint:
First: Hides any row in which all dates in that row are more than 7 days from the current date.
Second: For any cell with a date in bold and the date is today’s date or before, the cell text should be made white and the background red.
First: Hides any row in which all dates in that row are more than 7 days from the current date.
Second: For any cell with a date in bold and the date is today’s date or before, the cell text should be made white and the background red.