what i am trying to do is to have the conditional formatting highlight anything that is older than what ever month it currently is so like if i was to set the rule to =TODAY()-30 it would still include a couple of days of this month i want it to never include anything that is in the month that we are in.
Last edited by TwistedGhost; 06-07-2013 at 11:46 AM.
try
=MONTH(TODAY())-1
HTH
That does nothing.
USE conditional format
>>Format only cells that contain
>>dates occurring
>>last month
alternatively
if the cell in question is A1
conditional format Formula
Please Login or Register to view this content.
Last edited by humdingaling; 06-07-2013 at 12:07 AM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
not working for me but its not a huge issuie i have closed this thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks