MBellew1463
New Member
- Joined
- Jun 8, 2022
- Messages
- 10
- Office Version
- 2021
- Platform
- Windows
I wanted to see if the tab color can be changed based on data from another sheet. Sheets 1 through 100 will have data fed from another page within the workbook but the formatting needs to be done from the main page as sheets 1-100 change weekly and are imported from a separate report.
Basically want to change the tab color to RED of any sheet where the value in the the main sheet(JSR SUMMARY) = Forecast as follows
EDIT:
IF "JSR SUMMARY" sheet T4 = "Reforecast as Follows" then change tab color of Sheet1 to RED
Basically want to change the tab color to RED of any sheet where the value in the the main sheet(JSR SUMMARY) = Forecast as follows
EDIT:
IF "JSR SUMMARY" sheet T4 = "Reforecast as Follows" then change tab color of Sheet1 to RED
Last edited by a moderator: