ExcelBanter - Want to change text in a cell on sheet2 if date changed in sheet3.

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Want to change text in a cell on sheet2 if date changed in sheet3. (https://www.excelbanter.com/excel-programming/361017-want-change-text-cell-sheet2-if-date-changed-sheet3.html)

Kezza

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

All times are GMT +1. The time now is 11:11 PM.