Jeffrey Lebowski
Member
Hi All,
I have created a materials order tracking log (attached) for a friend. The ‘Orig’ tab is what he gave me, and initially had used colored rows to separate the different systems (column F) which caused him problems when sorting. My solution on the ‘Work’ tab was to conditionally format and color code the rows based on the system. This worked well but I think it can be better. The conditional formatting is set for a fixed range and a fixed number of systems. This poses two potential future problems:
1) Adding a new system – currently each new system would be added to the index page and a CF rule created on the main page.
2) Exceeding the "Applies To" range – the CF rules are all Applied To a fixed range. When the amount of data rows exceeds this range, each CF rule will need to be modified.
I am thinking it might work best to incorporate some VBA. I would really appreciate any suggestions on how to approach this problem.
Thank you!
I have created a materials order tracking log (attached) for a friend. The ‘Orig’ tab is what he gave me, and initially had used colored rows to separate the different systems (column F) which caused him problems when sorting. My solution on the ‘Work’ tab was to conditionally format and color code the rows based on the system. This worked well but I think it can be better. The conditional formatting is set for a fixed range and a fixed number of systems. This poses two potential future problems:
1) Adding a new system – currently each new system would be added to the index page and a CF rule created on the main page.
2) Exceeding the "Applies To" range – the CF rules are all Applied To a fixed range. When the amount of data rows exceeds this range, each CF rule will need to be modified.
I am thinking it might work best to incorporate some VBA. I would really appreciate any suggestions on how to approach this problem.
Thank you!