Thread: Data in cell changes then another cell data to change
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jennifer1960 Jennifer1960 is offline
external usenet poster
  
Posts: 7
Default Data in cell changes then another cell data to change
Need help to write formula or suggest a way of doing.

When Cell F3 is not equal to "CURRENT"
then where (G3:G10) contains X
change X to A.
Reply With QuoteReply With Quote