Prev: How can I keep a zero (0) at the front of a set of numbers.
Next: lookup function
From: mjones on 25 Jan 2010 20:17
Hi All,

Is there a way to format a cell based on the day of the month?

I'd like the cell colour to change if it's the 24th or 25th of the
month.

Thanks if you know.

Michele
From: Pete_UK on 25 Jan 2010 20:22
Michele,

Suppose your dates are in column D, starting with D2. Highlight the
cells from D2 down, then bring up the CF dialogue box. Select Formula
Is rather than Cell Value Is in the first box, and enter this formula:

=OR(DAY(D2)=24,DAY(D2)=25)

then click on the Format button and choose your background colour from
the Patterns tab. OK your way out.

Hope this helps.

Pete

On Jan 26, 1:17 am, mjones <mich...(a)quality-computing.com> wrote:
> Hi All,
>
> Is there a way to format a cell based on the day of the month?
>
> I'd like the cell colour to change if it's the 24th or 25th of the
> month.
>
> Thanks if you know.
>
> Michele

From: mjones on 25 Jan 2010 20:27
On Jan 25, 8:22 pm, Pete_UK <pashu...(a)auditel.net> wrote:
> Michele,
>
> Suppose your dates are in column D, starting with D2. Highlight the
> cells from D2 down, then bring up the CF dialogue box. Select Formula
> Is rather than Cell Value Is in the first box, and enter this formula:
>
> =OR(DAY(D2)=24,DAY(D2)=25)
>
> then click on the Format button and choose your background colour from
> the Patterns tab. OK your way out.
>
> Hope this helps.
>
> Pete
>
> On Jan 26, 1:17 am, mjones <mich...(a)quality-computing.com> wrote:
>
> > Hi All,
>
> > Is there a way to format a cell based on the day of the month?
>
> > I'd like the cell colour to change if it's the 24th or 25th of the
> > month.
>
> > Thanks if you know.
>
> > Michele

Thanks for replying. I need to clarify though.

I meant the actual day, like today() knows the actual date. The date
is not in a cell.

Is this still possible?
From: Pete_UK on 25 Jan 2010 20:41
In that case you would use this formula:

=OR(DAY(TODAY())=24,DAY(TODAY())=25)

Hope this helps.

Pete

On Jan 26, 1:27 am, mjones <mich...(a)quality-computing.com> wrote:
>
> Thanks for replying.  I need to clarify though.
>
> I meant the actual day, like today() knows the actual date.  The date
> is not in a cell.
>
> Is this still possible?
From: mjones on 25 Jan 2010 20:49
On Jan 25, 8:41 pm, Pete_UK <pashu...(a)auditel.net> wrote:
> In that case you would use this formula:
>
> =OR(DAY(TODAY())=24,DAY(TODAY())=25)
>
> Hope this helps.
>
> Pete
>
> On Jan 26, 1:27 am, mjones <mich...(a)quality-computing.com> wrote:
>
>
>
> > Thanks for replying.  I need to clarify though.
>
> > I meant the actual day, like today() knows the actual date.  The date
> > is not in a cell.
>
> > Is this still possible?

Great. Thanks!!!!
 |  Next  |  Last
Pages: 1 2
Prev: How can I keep a zero (0) at the front of a set of numbers.
Next: lookup function