My excel sheet is made to input an "a" for accepted, which turns the cell green; and an "r" for rejected and the cell turns red. I want to be able to have the cell time stamped with the date. I already formated it to turn the different colors based on the "a" or "r". How do I format it to include the time stamp in each individual cell as well?
Hi,
if the cell already contains a text value like "a" or "r" then it cannot also contain a time stamp. You can put a time stamp into an adjacent cell, if required, but it will require VBA code. Just search this forum for "time stamp" to see half a gazillion examples about how to achieve that.
regards
Is there a way for the "a" to turn into the date and turn the cell green? Same for the "r" to turn into the date and turn red?
i do not know the purpose of your spreadsheet, so may be i am being presumptuous.
can you have two separate columns - one called Accepted and another called Rejected? if so, instead of entering "a" and "r", you could use the CTRL + SHIFT + ; feature to instead insert the current time directly into a cell in the appropriate column. and, then, you could use conditional formatting to change the colours, if you please.
else, you need to go the VBA route for reusing the same cell.
Last edited by icestationzbra; 05-08-2012 at 10:27 AM. Reason: add'l info
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Hi
As npamcpp's already told you, you can not do it to the same cell.
Maybe you can use a helper and hidden column and do a combination of these...
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
So what exactly do I need to do as an excel newb
If your value "a" or "r" is in cell A1, use a VBA macro to put a time stamp into cell B1.
As I said before, search this site for "time stamp" to find lots of examples: https://www.google.co.nz/search?sour...excelforum.com
I think that we can also do this, without macro.
@fotis: you have piqued my curiosity :-)...
How can I do this?Originally Posted by Fotis1991
May i see in small sample workbook, how your data looks like?
pic.JPG
basically it will be a running tally of accepted vs rejected forms.
Sorry but i can not work to a picture. Can you?
how do I insert my excel sheet in this forum?
Same way as the picture, OR
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
QBMS Online.xlsx
there you go! Thanks.
I think that i am very tired...
But i'll explain what i mean with TimeStamp and conditional formating in my example.
Hope to helps you.
Thanks Fotis.
brilliant use of "classical" circular referencing, Fotis!
Last edited by icestationzbra; 05-08-2012 at 09:43 PM. Reason: adjectival enhancement
Fotis, can you apply your formating to the excel sheet I sent you? I can't figure it out. Thank you.
Sure. I can.
But i have a small....problem...
I can not understand in your sample, where you want to type "a" or "r"(which column) and where you need the Time stamp(which column)..Pls, tell me.
That's why i told you yesterday, that i was very tired....
Attached should be easier to understand. It would be great if the "a" would simply get replaced by the date and turn green just as "r" would turn red and place the date, if not, placing the date in the next cell would give us the date.QBMS Online.xlsx
Hi
Even now, i am not sure that i understand well your requirement.
Take a look to your example.
I can say for sure that we can not, use in the same call, Time stamp and something else.
Is this, works for you?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks