Conditional Formatting -II Thick Box border

I have a sheet where Row 26 has Dates.
I want to write a macro that if the dates in row 26 is 10/27/2013,11/3/2013,11/10/2013,11/17/2013 or 11/24/2013 then select the column from row 26 till the end of the column where it finds the last data and give that a thick box border.

Any help is appreciated!
thanks!

Can you explain this part in more detail:

Originally Posted by pdalal

if the dates in row 26 is 10/27/2013,11/3/2013,11/10/2013,11/17/2013 or 11/24/2013

What does the layout of this row look like? Do you mean if any of these dates are found anywhere in the row, or in a specific position?

Hi 6string jazzer,
The macro works but it only does the box border on the cell with date 10/20 .It is supposed to do for date =10/27 and <=11/24
Also is there a way to get "All borders " as supposed to just the exterior border.
Thanks!

...it only does the box border on the cell with date 10/20 .It is supposed to do for date =10/27 and <=11/24

Your description said:

...select the column from row 26 till the end of the column where it finds the last data and give that a thick box border.

The first column for 10/20 is the only one that has data. The other columns with dates 10/27 - 11/24 have no data. Therefore no boxes.

Did you mean that you want the box around cells even if there is no data? If so, here is a revision, which also boxes each individual cell.

Please Login or Register  to view this content.