Conditional Formatting for month only

[SweetBones]

I'm trying to have a cell highlight red if it is the current month, orange if next month. The actual input is text exa "January". Not a date. Is there a way where we can do this to where it will always highlight the current month even if the sheet is viewed in say... March?

 

[FormR]

Assuming your celll containing month is A1 try using this formula in conjuction with the "Use a formula to determine which cells to format" conditional formatting:

=A1=TEXT(TODAY(),"mmmm")

 

[Skybluekid]

Is the cell you want highlighting the same cell as you input the month?

 

[SweetBones]

yes. some more background of what i'm trying to do: We have to preform an assessment for each persons birth month. so if i have a column of people's birth month i want to have the current month highlighted in red so that people know that these members need to be seen. then orange for next month so that they can schedule that assessment but have it be dynamic in the way that if we view it in feb then feb will be the current month highlighted. I dont even know if this is possible.

 

[FormR]

Do you know how to apply conditional formatting; using the "Use a formula method"?

If so try:

Excel Workbook
	A
1	Birth Month
2	January
3	March
4	February
5	April
6	May
7	January
8	December
9	March
10	February
11	May
12	January
13	January
14	March
15	February
16	May
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2	1. / Formula is =A2=TEXT(EDATE(TODAY(),1),"mmmm")	Abc
A2	2. / Formula is =A2=TEXT(TODAY(),"mmmm")	Abc

 

[shyy]

something liek this?

Excel 2010
	A	B	C	D
9	1/5/2015	1/30/2014	TRUE	highlight red
10	2/1/2014	1/30/2014	TRUE	highlight orange
11	3/1/2014	1/30/2014	FALSE
Sheet1

Cell Formulas
Range	Formula
B9	=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))
B10	=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))
B11	=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))
C9	=IF(MONTH(A9)=MONTH(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))),TRUE,FALSE)
C10	=IF(MONTH(A10)=MONTH(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())))+1,TRUE,FALSE)
C11	=IF(MONTH(A11)=MONTH(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())))+1,TRUE,FALSE)

 

[FormR]

Shyy, I don't know if this is still true - but see below from post #1.

The actual input is text exa "January". Not a date.

 

[shyy]

gotcha, missed that.