Two separate problems: Getting month for date from formula field, and cond.form. columns.

Sorry, hard to make this a really descriptive title.

I am having trouble figuring out two separate things that aren't really related, but I figured they could be consolidated to one thread since they should be fairly simple:

The first is pulling the month for a date field from another field that is getting the month from the title of the worksheet.

So the formula in A1 is:

Please Login or Register  to view this content.

The title of the worksheet is "January" (although each worksheet will have a different month name), so A1 is filled with "January".

I want A4 to be formatted with 1-Jan, pulling the month from A1, so that changing the title of the worksheet changes the month in A1, and A4.

I tried

Please Login or Register  to view this content.

hoping that it would format it as a date after filling it as text, but it stays as "1-January". A5 which is

Please Login or Register  to view this content.

still recognizes A4 as a date and formats as "2-Jan".

I tried putting "mmm" somewhere in there to get January to format to Jan, but that didn't seem to work. I tried

Please Login or Register  to view this content.

but it seems to not recognize "January" from A1 as a month.

Here's the worksheet for this: Book2.xlsx



Issue number 2 is how to format entire columns if a row in that column meets certain conditions.

I have this one to format rows when the day in column B is "Sun":

Please Login or Register  to view this content.

But I can't figure out how to get something similar to apply to an entire column when the string in row 3 is equal to something. I also don't exactly understand why the above code works, I just found it with google. Why does it need the 1?

I also have one small question about the same code above. It seems to have left some residual borders from before the days shifted by changing the month. You can see this in the attachment. Why? And how do I fix it without manually changing the borders for all those rows?

Thanks, that worked well, and I'm sure knowing that the "LEFT" function exists will be helpful later.

A shorter form of Brendan's answer:

="1-"&LEFT(A1,3)