View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kezza Kezza is offline
external usenet poster
 
Posts: 13
Default Want to change text in a cell on sheet2 if date changed in sheet3.

Hi all,
I am copying a data range from sheet2 to sheet3 by identifying YES
(conditionformatted 1,red) in column G sheet2, working fine. After
adding extra data in sheet 3, I would now like to go back to Sheet2 and
have YES changed to LOGGED (Condition formatted 2,Blue).
Thanks for any help
Regards
Kezza