Greetings,
I am looking for some help with conditional formatting. In a different cell I have a date stamp (Time and date) I want to use formatting in a different cell based on that date. However I want it to format the cell when the time stamp is before noon of that day (timestamp date not current day).
You need to create a TRUE/FALSE statement. Assuming the timestamp is in cell A1, something like this:
=MOD(A1,1)<0.5
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Another one...
A2 = date/time stamp
=HOUR(A2)<12
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks