Conditional Formatting Issue

[Mojo689]

I have a table in which I am setting conditional formatting for entire row if the date in column A is within the 3rd week of the month. It will highlight the date in column A but not the entire row.

Table is a mix (first row is A12, after column headers):
column A = date (each row is the Weds of each week)
columns B:E = are just text

With all rows in table highlighted (starting in A12), Conditional formatting formula is:
"=INT((13+DAY(A12)-WEEKDAY(A12-4))/7)=3"

This does the job and highlights the 3rd week of each month in Column A (yay), but not the entire row I really need the entire row highlighted

I've tried "=$A12=INT((13+DAY(A12)-WEEKDAY(A12-4))/7)=3"
I've tried "IF(...."
I've tried adding IF(WEEKNUM(...

What am I missing?

 

[Chrisdontm]

While highlighting the whole area, try this:

=INT((13+DAY($A12)-WEEKDAY($A12-4))/7)=3

 

[Mojo689]

While highlighting the whole area, try this:

=INT((13+DAY($A12)-WEEKDAY($A12-4))/7)=3

That's what I have already and it only formats the date but not the entire row (set to fill the entire row with color and bold the text). Table set up like this:

A B C D E
Jan 02
Jan 09
Jan 16
Jan 23
Jan 30
Feb 06
Feb 13
Feb 20
Feb 27
Mar 06
...


I also have formatting within this table to format any week that falls in July and August (basically grey out the entire row for each week/month). That is working just fine. Frustrating!!

 

[Mojo689]

Sorry, that didn't come out looking right. Column A is the date, columns B to E are cells where text will be manually entered.

 

[Chrisdontm]

That's what I have already and it only formats the date but not the entire row...

That is not what you have already.
You are missing the absolute references on the columns...
It is what you are wanting, try it. ( Refer to post # 2 )