sanityendshere
New Member
- Joined
- Aug 7, 2020
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
Hey everyone,
I am producing tables from a database that can contain multiple pages of data. One of the report requirements is to change ND to silver or -0349986266670736. I know I could technically do all of this with conditional formatting; however, I have written VBA for all of the other table formattings and was hoping I could add code to change ND to the silver color. I've been looking online and have been unsuccessful to find code that will work for what I need. Is this even possible? If so, will someone help me out with the code for this particular instance? Thanks in advance for any help you can provide.
I am producing tables from a database that can contain multiple pages of data. One of the report requirements is to change ND to silver or -0349986266670736. I know I could technically do all of this with conditional formatting; however, I have written VBA for all of the other table formattings and was hoping I could add code to change ND to the silver color. I've been looking online and have been unsuccessful to find code that will work for what I need. Is this even possible? If so, will someone help me out with the code for this particular instance? Thanks in advance for any help you can provide.