Z
zym1ne
Complete newbie to VB here so forgive me if this is a little cryptic...
Have a worksheet that I keep track of 6 reps with, their names are i
Col 'C' on the worksheet and Col's A-H contain the data such as dates
deals etc...
What I have tried and failed to do so far is a conditional format tha
will allow me to auto colour cells for each rep.
IE:
The reps name is entered into Col 'C' and when done this will aut
colour cells A-H for that row.
Each rep has multiple entries within the workbook so at a glance wit
them colour coded I can see a breakdown.
If this makes any sense and anyone can offer some guidance woul
appreciate it
many thanks
zy
Have a worksheet that I keep track of 6 reps with, their names are i
Col 'C' on the worksheet and Col's A-H contain the data such as dates
deals etc...
What I have tried and failed to do so far is a conditional format tha
will allow me to auto colour cells for each rep.
IE:
The reps name is entered into Col 'C' and when done this will aut
colour cells A-H for that row.
Each rep has multiple entries within the workbook so at a glance wit
them colour coded I can see a breakdown.
If this makes any sense and anyone can offer some guidance woul
appreciate it
many thanks
zy