Enter cell with specific term conditionally
Posted on 2014-07-22
on the selected cells (contiguous selection) I would like to run the following macro:
If the macro detects cells shaded with RGB (211, 211, 211) the term 'Item_No' is to be entered
If the macro detects cells shaded with RGB (195, 187, 132) the term 'Stock' is to be entered
Any other shading no entry has to be effected.
Help is much appreciated. Thank you very much in advance. Regards, Andreas