Hello all, I have a spreadsheet that is received and I would like to conditionally format certain cells based on a specific rule type. Here is what I am trying to do.
1. Copy data from Lines A3:AE25 and paste into a preexisting template file Starting from line A3
2. Save new excel sheet with a dialogue box requesting renaming of the sheet and save in Documents folder.
3. I require certain fields to be highlighted based on a predefined set of rules. Ex:
Column C houses rules anywhere from 1-20. As an example, Rule 1 requires fields D3 and F3 to have a value so I would want this highlighted in green if there is a value present. If there is a blank value or text containing the word “Required”, this field should be formatted red.
Rule 1 might also have fields that are optional like E3 and G3. I would like these to be highlighted in Orange if there is a value present or if it has the text “optional” in it. It should be highlighted in red if there is a blank.
Other fields that are not supposed to have any values values should remain blank without any formats, but if it does have a value, I would like this to have a background color of red.
There are multiple rules that have varying fields of required/optional so a VBA script that would conditionally format these specified cells would really make things easier and reduce human error. Any help in creating a template script for two rules would be great, the rest I would be able to add myself. Thanks in Advance!!
1. Copy data from Lines A3:AE25 and paste into a preexisting template file Starting from line A3
2. Save new excel sheet with a dialogue box requesting renaming of the sheet and save in Documents folder.
3. I require certain fields to be highlighted based on a predefined set of rules. Ex:
Column C houses rules anywhere from 1-20. As an example, Rule 1 requires fields D3 and F3 to have a value so I would want this highlighted in green if there is a value present. If there is a blank value or text containing the word “Required”, this field should be formatted red.
Rule 1 might also have fields that are optional like E3 and G3. I would like these to be highlighted in Orange if there is a value present or if it has the text “optional” in it. It should be highlighted in red if there is a blank.
Other fields that are not supposed to have any values values should remain blank without any formats, but if it does have a value, I would like this to have a background color of red.
There are multiple rules that have varying fields of required/optional so a VBA script that would conditionally format these specified cells would really make things easier and reduce human error. Any help in creating a template script for two rules would be great, the rest I would be able to add myself. Thanks in Advance!!
