M
magmike
Currently I use the daylights out of Conditional Formatting in my
Workbook which has multiple sheets - one sheet for each zip code and
each row in each sheet represents a company and their related
information.
My conditional formatting is based on one column (E) and based on the
text, colors that entire row. The text in the column is related to the
status, such as "cb" for call back, "quote" to generate a quote,
"done" means this customer is completed, etc. There are currently 8
different "codes".
I would like to move this to VB, so it is easier to update all the
sheets when I make additions or changes to the conditional formatting.
In addition, so that it is easier for those not at all familiar with
vb to make changes to the conditional formatting, it would be great if
I could have a sheet that the vb would refer to for the rules, with a
column listing the "code" and the column next to it would contain the
formatting to apply to the row when the target column equals the code.
Is this at all possible? If so, any guidance would be much
appreciated.
Thanks in advance for your help,
magmike
Workbook which has multiple sheets - one sheet for each zip code and
each row in each sheet represents a company and their related
information.
My conditional formatting is based on one column (E) and based on the
text, colors that entire row. The text in the column is related to the
status, such as "cb" for call back, "quote" to generate a quote,
"done" means this customer is completed, etc. There are currently 8
different "codes".
I would like to move this to VB, so it is easier to update all the
sheets when I make additions or changes to the conditional formatting.
In addition, so that it is easier for those not at all familiar with
vb to make changes to the conditional formatting, it would be great if
I could have a sheet that the vb would refer to for the rules, with a
column listing the "code" and the column next to it would contain the
formatting to apply to the row when the target column equals the code.
Is this at all possible? If so, any guidance would be much
appreciated.
Thanks in advance for your help,
magmike