beginvbaanalyst
Board Regular
- Joined
- Jan 28, 2020
- Messages
- 141
- Office Version
- 365
- Platform
- Windows
Hi Everyone,
Providing context.
I'm creating a custom document which allows my company to be more efficient when compared with single users; this allows the single user to do multiple requests at once while pre-validating entire sets of data.
I have a post validation tab that does all the necessary updates, but I thought of a process where if a value comes back as zero I'd like it to highlight the field in the other tab(s).
In this screenshot I have my values that return as 0 but I want it to go one step further.
I would like it to search in my other tab, (well call this tab LIST) these specific sets of assortments that came back as 0.
Anywhere in the document with these names would then be highlighted for the user.
Would this be a rule or would this be VBA?
Please help.
Providing context.
I'm creating a custom document which allows my company to be more efficient when compared with single users; this allows the single user to do multiple requests at once while pre-validating entire sets of data.
I have a post validation tab that does all the necessary updates, but I thought of a process where if a value comes back as zero I'd like it to highlight the field in the other tab(s).
In this screenshot I have my values that return as 0 but I want it to go one step further.
I would like it to search in my other tab, (well call this tab LIST) these specific sets of assortments that came back as 0.
Anywhere in the document with these names would then be highlighted for the user.
Would this be a rule or would this be VBA?
Please help.
