RealThoughts
New Member
- Joined
- Nov 6, 2019
- Messages
- 4
Hello,
This may or may not be a simple porcess as I am very new to coding for macros. I have 3 processes I want to implement into my excel.
First, I want to change my current highlighting process for columns I & J. They are highlighted green for all non-blank-cells. I wish to highlight them different colors based on the values in column G. So for example, I have "Call Later" in column G, so in column I and J they would be yellow. Then for "Will revert back" I would like I and J to be blue.
Next, I would like to implement something like a notification process where for the ones highlighted, I would like to have it populate automatically in 7 days of the date in column D to say "It has been 7 days since the last action with the customer. Please call/email them again."
Lastly, again using the higlighted I and J, I would like to find a way to have excel automatically select "yes" in column P where the cells are highlight yellow in column I and J.
Sorry for the long post.
https://drive.google.com/file/d/1_LJECLlHUWCrWVhMXPmyJ9wNuuvkWkTv/view?usp=sharing
This may or may not be a simple porcess as I am very new to coding for macros. I have 3 processes I want to implement into my excel.
First, I want to change my current highlighting process for columns I & J. They are highlighted green for all non-blank-cells. I wish to highlight them different colors based on the values in column G. So for example, I have "Call Later" in column G, so in column I and J they would be yellow. Then for "Will revert back" I would like I and J to be blue.
Next, I would like to implement something like a notification process where for the ones highlighted, I would like to have it populate automatically in 7 days of the date in column D to say "It has been 7 days since the last action with the customer. Please call/email them again."
Lastly, again using the higlighted I and J, I would like to find a way to have excel automatically select "yes" in column P where the cells are highlight yellow in column I and J.
Sorry for the long post.
https://drive.google.com/file/d/1_LJECLlHUWCrWVhMXPmyJ9wNuuvkWkTv/view?usp=sharing
