Excel SharePoint Script
Budget: $30 – $250 USD
For a shared Excel file on Sharepoint, need two scripts (or a way to do the following):
1. On opening the Excel file, hide any row in which all dates in the row are more than 7 days from the current date.
2. On opening the file, any cell that has a date with text in bold and the date is today or before, will have the cell background turn white and the cell text turn red.
1. On opening the Excel file, hide any row in which all dates in the row are more than 7 days from the current date.
2. On opening the file, any cell that has a date with text in bold and the date is today or before, will have the cell background turn white and the cell text turn red.