nishanthc23
New Member
- Joined
- Nov 22, 2021
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
I have 2 sheets, one with Master Data and other is the Layout template. I want to format the Sheet 2 cells to GREEN color based on the Status column value in Sheet 1, if it is equal to 'Available'.
please anyone advise, can I achieve this by VBA in a range on cells in Sheet 2.
Sheet 1 - Master Data
Sheet 2- Layout
please anyone advise, can I achieve this by VBA in a range on cells in Sheet 2.
Sheet 1 - Master Data
Sheet 2- Layout