Hi,

Is it possible for me to encrypt/decrypt a only a certain cells in a column based on value in another column? For example below, I want to encrypt data in column value, but only if the company is C or D. If the company is A or B, the value should remain appear as it is without being encrypted. Is this possible? What's the VBA code to do this?

Company Value
A 20
B 30
B 40
C 40
D 60
C 80