Using a Time Stamp / Conditional Formatting

[prephil]

I want to be able to add a timestamp in a cell / colum in which I'm using conditional formatting in. I have the conditional formatting set up as follows:
If the user enters the text Complete, the cell turns green.
If th user enters the text Pending the cell turns blue.

Now unfortunately I'm ignorant of VBA & not so hot on Excel so if anyone does reply with VBA code, I'd possibly need a link to basic instructions on how to implement a solution using VBA.

I have seen the below thread & it is a bit initimidateding seeing the code. It's kina similar to what I want to do.

Time stamp a cell based on text entry

Hi All, I am trying to time stamp a cell in excel to show the time and date an entry was made. I pulled the below code from the net and modified it with the if statement. It works in the way I want but the issue is when I duplicate it down the column for time stamping each entry all the time...

www.mrexcel.com

 

[etaf]

how about these 2 non vba solutions

https://howtoexcelatexcel.com/excel-tips-tricks/create-a-timestamp-in-excel-with-formulas/

How to insert timestamps in excel sheet using formulas

Often when you use excel to track a particular item (like expenses, exercise schedules, investments) you usually enter the current date (and time). This is nothing but timestamping. Once the item is time stamped, it is much more easier to analyze it. Here is an excel formula trick to generate...

chandoo.org

 

[Joe4]

If you require a VBA solution, please provide the following:
- What column the words "Complete" and "Pending" are being entered in
- What exact conditions should cause the TimeStamp to be entered
- What column the TimeStamp should be entered in