If i add a static date stamp to a cell ,s6, using ctrl colon , Can this then show the word 'complete' in T6 ?
i have tried this but doesn't work .
=IF($S$6="today()","complete")
If i add a static date stamp to a cell ,s6, using ctrl colon , Can this then show the word 'complete' in T6 ?
i have tried this but doesn't work .
=IF($S$6="today()","complete")
paste this
=IF($S$6=today(),"complete")
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Hi
Try this.
=IF(S6=TODAY(),"complete","")
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.
You may also want to cater for the case that S6 is not equal to today's date. In the formula above, the result would be FALSE, which does not look pretty. So maybe
=IF($S$6=today(),"complete","")
hi thanks for your replies but i still can't get it to work
i have this formula in cell s6 as well , would this make a difference to the formuls i require for t6?
=$S6=TODAY()
.. Do you mean in S6, , you have this formula??
=$S6=TODAY()
Why?
This formula allows me to to colour all the previous cells in row 6 when i add the date to s (ctrl colon) then i want it to say 'complete' in row t
You use this formula to Conditional format rules.. Not in the cell...
Can you upload a small sample workbook?
Maybe You should upload sample (excel file) It will be much easier
wflowmacro.xlsm
hi guys , i'm after colouring t6 green and adding 'complete' when s6 has the dat addad to it .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks