I am trying to use conditional formatting to change the fill. In (A1-A50) I have the birth month of my personal. What I need is for the month to turn Yellow if it is within the next two months from the curent month. If it is the curent month I need it to be red and for all the other months I need it to be green. I tryed using the today function but it is based off of day and year.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional Formatting By Month(text)
- Thread starter jhat530
- Start date
barry houdini
MrExcel MVP
- Joined
- Mar 23, 2005
- Messages
- 20,825
Hello jhat530, welcome to MrExcel
If you have the months as text in A1:A50 then try this
Put this formula in E1
=TODAY()
select the range A1:A50 and use these conditions in this order in conditional formatting
condition 1
=A1=TEXT(E$1,"mmmm")
format red
condition 2
=DATEDIF(E$1-DAY(E$1)+1,1&A1&YEAR(E$1)+1,"ym")<3
format yellow
condition 3
=A1<>""
format green
In Excel 2007 or 2010 if you input the conditions in that order they actaully appear in reverse order, so either add those in reverse order or change the order of application afterwards with the up and down arrows
If you have the months as text in A1:A50 then try this
Put this formula in E1
=TODAY()
select the range A1:A50 and use these conditions in this order in conditional formatting
condition 1
=A1=TEXT(E$1,"mmmm")
format red
condition 2
=DATEDIF(E$1-DAY(E$1)+1,1&A1&YEAR(E$1)+1,"ym")<3
format yellow
condition 3
=A1<>""
format green
In Excel 2007 or 2010 if you input the conditions in that order they actaully appear in reverse order, so either add those in reverse order or change the order of application afterwards with the up and down arrows
Upvote
0
Similar threads
- Question
