Well, what I want to do is edit if a particular cell has a particular value.
For example, if cell A18 has any number higher than 6, it will make the value of cell O2 say
=A18*0.5, however, if it says 6, O2 will say
Do you understand what I am talking about? If you are, can you please find a good macro to do this?
Thanks, all hope appreciated. :)