View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Hayes Colin Hayes is offline
external usenet poster
 
Posts: 465
Default Selective cell changes

HI

In column Y I have a row of numbers.

I need to change them so that the cells which are 0 stay the same , and
cells with numbers greater than 0 in them are replaced with the word
'Active' .

Can someone help with this?

Thanks.