I wish to have a field in a column change its background colour to red only if the date in the field due in the next 6 months.
the format the date is in is: dd/mm/yyyy
Can anyone advise how I should use to do this.
I have looked at some of the conditional date occuring formats and just can not see one that allows anything more than a month.
Last edited by Jason_C; 11-03-2010 at 05:24 PM.
Assuming the DUE field is column M, use this conditional formatting on that column:
Condition1: Formula Is: =$M1 - TODAY() < 183
Format... Pattern tab: Red
_________________
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!)
That worked well, except that the other cells that are empty in that column are now also yellow-filled background like the fill I used to highlight the dated cells (in addition to the red font). Is there some way to make the empty cells, or the ones that don't have dates in them, but just text, like the title bar, not turn red font, and yellow-filled?
Maybe add a second test to insure M1 isn't blank:
Condition1: Formula Is: =AND($M1>0, $M1 - TODAY() < 183)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks