我有十個人ge會員證ge有效日期，我想做一個動作或公式，使到過期ge會員ge日期顯示為紅色，我有佢每日自動detect！
依照上題，我又有另一個疑問：如果我部腦係英文，而佢ge日期係：6/21/2007咁ge模式，咁我set ge時候就出左問題，得唔到要ge結果！有咩辦法？救救我！pls~thx~
有關Excel！
2007-06-25 6:00 am
回答 (2)
2007-06-30 7:05 pm
✔ 最佳答案
First question, Go to the cell of member date, use conditional formatting in format. Set the condition :
Cell value is less than $A1$ (assume A1 cell is the current date, formula is @now ( ) .
Format : change font to red color.
It will satisy you need.
Second question,
It is the date format issue, if you want to compliant with the same format, you have to change the format from Windows. Go to control panel > regional and language option > change the short date format to mm/dd/yy.
Bear in mind that it will change all date format in using all software.
Any problem, send me e-mail.
2007-06-26 2:07 am
收錄日期: 2021-04-18 22:36:02
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070624000051KK04486