How do I copy conditional formatting from one worksheet to another in the same workbook?

Question

I am using Office 2010 and created a spreadsheet that I use to track monthly bills to reflect them as paid and show a remaining amount outgoing for the month.  I used Data Validation for a drop down list = Months so that I could select the month paid rather than having to type it in each time.  However for ease of viewing I used conditional formatting to highlight the row once the bill was paid for the current month and an "IF" statement in a column to change the amount to zero for that row when it was paid --I have a sum at the end of this column that reflects the total amount remaining to be paid for the month.  Created this sheet in May and after much research and deliberation was able to get the conditional formatting to work; then I realized I wanted a different sheet for each month and used the Move/Copy function on the tab to create the additional sheets.  However even though it appears the conditional formatting was copied, now it will not work.  Subsequently I tried copy and paste special but it still does not work like it did previously.  An example row from the sheet shows below-- shows below first cell(A2) is the bill name, second (B2)is the amount due, third (C2)is the due date, fourth (D2) is the drop down list of months, fifth (E2) is cell with "IF" statement. At the bottom of Column E is the SUM of the amounts. 

Used a formula to determine which cells to format and tied it to the cells with the drop down list. Formula is this =$D2=TEXT(NOW(),"mmmm") and it applies to =$A$2:$D$23,$C$24 and simply changes the cells to fill with green when cells in column D are current month. Though I am not sure (other than my happy use of the format painter) how the $C$24 cell was captured as that cell does not need this formatting). 

The IF statement reads for the last column as **=IF(D2=TEXT(NOW(),"mmmm"),0,B2)**Basically I wanted to show a zero in column E cells if the bill is paid for the current month and if not repeat the value in column B so the amount is still reflected outstanding in the SUM at the bottom of column E.

I am unsure why this will no longer work that for the following months; someone has advised me that the drop down list is not a value identified and that could be part of the reason.  I am now thinking I will need to change the month paid to state "PAID" and adjust my formatting and IF statement to compensate.  Any help would be appreciated.

CONDO FEE	130.66	1	APRIL	130.66

Answer 1

OK. In that case, without seeing the workbook I give up.

If you'd like to post the workbook on a public website I'll take a look.

Redact it if necessary, leaving enough to see the issue.

Answer 2

No it does not contain 3 character months.  The Full spelling of the months are used in the drop down list.

Answer 3

That doesn't answer the question..

I will rephrase it: Does MONTHS contain 3-character months?

If so, change "mmmm" to "mmm"

Answer 4

No Column D has Data Validation in the form of a Drop Down List where the source =MONTHS.  I am trying to mess with it now removing the drop down list and changing the value to just show the word paid (where I would have to manually type it in) but am unfamiliar with how to change the IF statement in Column E to recognize the word "PAID"

Answer 5

Does your column D contain just 3-character months, like "May" and "Jun"

If so, change your conditional format to use "mmm" instead of "mmmm"