Replace range of numeric values with text

Closed
mat7 - Feb 16, 2010 at 02:49 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 16, 2010 at 05:28 PM
Hello,

I have an Excel report and I need to change all numercial values that are less than 5 to "NIL" and all those greater than 5 to "YES".

Im pretty new at macros so can you really spell out for me what needs to be done!!!!!

Thanks.

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 16, 2010 at 05:28 PM
when you say all, you mean like every where in the sheet or just a certain column ?
1