conditional format, day of month

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amber - 02 May 2008 18:50 GMT

I have a column filled with sequential dates. Cell A41 will always be the
30th day of a month, cell A42 will be EITHER the 31st day of that month OR
the first day of the next month. IF A42 is the first day of a month I would
like to format it with white text. I understand how to use conditional
formatting (change text color) but what should the condition state? I tried;
"If the cell value is less than =DAY(31)" but that's not right.

Reply to this Message

Reitanos - 02 May 2008 19:11 GMT

If A42 is the first of the month is the test, then:
=DAY(A42)=1
would be the formula.
I hope you have a color in that cell, unless you are planning on the
text not being visible.

> I have a column filled with sequential dates. Cell A41 will always be the
> 30th day of a month, cell A42 will be EITHER the 31st day of that month OR
> the first day of the next month. IF A42 is the first day of a month I would
> like to format it with white text. I understand how to use conditional
> formatting (change text color) but what should the condition state? I tried;
> "If the cell value is less than =DAY(31)" but that's not right.

Reply to this Message

Sandy Mann - 02 May 2008 19:16 GMT

If you mean dates and not just numbers then in A40 enter the date for the
28th day of the month. In A41 enter:

=IF(A40="","",IF(MONTH(A40)=MONTH(A40+1),A40+1,""))

this will return empty strings if for date the *would* have been in the
following month.

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

>I have a column filled with sequential dates. Cell A41 will always be the
> 30th day of a month, cell A42 will be EITHER the 31st day of that month OR
[quoted text clipped - 4 lines]
> tried;
> "If the cell value is less than =DAY(31)" but that's not right.

Reply to this Message

Sandy Mann - 02 May 2008 19:20 GMT

In case you are not one of the mind readers around here and cannot read my
mind, enter the formula in A41 and drag down to A43 on the fill handle.

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> If you mean dates and not just numbers then in A40 enter the date for the
> 28th day of the month. In A41 enter:
[quoted text clipped - 13 lines]
>> tried;
>> "If the cell value is less than =DAY(31)" but that's not right.

Reply to this Message

Amber - 02 May 2008 20:37 GMT

Thank you. You actually read my mind, when I said I wanted "white font" I
just wanted it invisible. This worked!

> In case you are not one of the mind readers around here and cannot read my
> mind, enter the formula in A41 and drag down to A43 on the fill handle.
[quoted text clipped - 16 lines]
> >> tried;
> >> "If the cell value is less than =DAY(31)" but that's not right.

Reply to this Message

Sandy Mann - 02 May 2008 20:51 GMT

Glad that it helped. Thanks for the feedback.

Signature

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> Thank you. You actually read my mind, when I said I wanted "white font" I
> just wanted it invisible. This worked!
[quoted text clipped - 23 lines]
>> >> tried;
>> >> "If the cell value is less than =DAY(31)" but that's not right.

Reply to this Message