I have a table of colours by stock category
I have 5000 lines which I don't want to do
manually , I want click and done
Shade column C according to table A
See attached
I have a table of colours by stock category
I have 5000 lines which I don't want to do
manually , I want click and done
Shade column C according to table A
See attached
If this is a one-off job then simply filter the column on each item, highlight the column and format it accordingly. 15 iterations of that and you're done.
If someone has helped you then please add to their Reputation
Apply conditional formatting on one sheet and then copy paste the format onto the column.
To understand better , i have attached your sheet with a few conditional formats.
Happy Computing ,
Xlbiznes.
To show your appreciation please click *
Hi makinmomb,
Try the following code which is duplicated in the attached sample working file.
Lewis
Please Login or Register to view this content.
LJMetzger exactly as needed ,
sorting 7500 rows would be long enough
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks