software

My formula produces a dd-mmm-yyyy result which is correct.

Cell L55 formula results a 17-May-2006

Conditional formatting is set to: Formula is: =L55lt;=TODAY()

With background pattern set to red.

My problem is that the conditional formatting doesn’t produce the results I
desire which is that if the date in L55 falls within the month and year that
the background will be red.

How do I get the conditional formatting to do this?I'm still not exactly sure what you mean. If you want it to highlight if
the date and month are in the current month try this in your formula for
conditional formatting.
=AND(MONTH(A1)=MONTH(TODAY()),YEAR(A1)=YEAR(TODAY( )))quot;Clydequot; wrote:

gt; My formula produces a dd-mmm-yyyy result which is correct.
gt;
gt; Cell L55 formula results a 17-May-2006
gt;
gt; Conditional formatting is set to: Formula is: =L55lt;=TODAY()
gt;
gt; With background pattern set to red.
gt;
gt; My problem is that the conditional formatting doesn’t produce the results I
gt; desire which is that if the date in L55 falls within the month and year that
gt; the background will be red.
gt;
gt; How do I get the conditional formatting to do this?
gt;

Try =AND(MONTH(L55)=MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Clydequot; gt; wrote in message
...
gt; My formula produces a dd-mmm-yyyy result which is correct.
gt;
gt; Cell L55 formula results a 17-May-2006
gt;
gt; Conditional formatting is set to: Formula is: =L55lt;=TODAY()
gt;
gt; With background pattern set to red.
gt;
gt; My problem is that the conditional formatting doesn't produce the results
gt; I
gt; desire which is that if the date in L55 falls within the month and year
gt; that
gt; the background will be red.
gt;
gt; How do I get the conditional formatting to do this?
gt;
Hi Barb,Thank you very much your solution worked perfectly.

Clyde
quot;Barb Reinhardtquot; wrote:

gt; I'm still not exactly sure what you mean. If you want it to highlight if
gt; the date and month are in the current month try this in your formula for
gt; conditional formatting.
gt; =AND(MONTH(A1)=MONTH(TODAY()),YEAR(A1)=YEAR(TODAY( )))
gt;
gt;
gt; quot;Clydequot; wrote:
gt;
gt; gt; My formula produces a dd-mmm-yyyy result which is correct.
gt; gt;
gt; gt; Cell L55 formula results a 17-May-2006
gt; gt;
gt; gt; Conditional formatting is set to: Formula is: =L55lt;=TODAY()
gt; gt;
gt; gt; With background pattern set to red.
gt; gt;
gt; gt; My problem is that the conditional formatting doesn’t produce the results I
gt; gt; desire which is that if the date in L55 falls within the month and year that
gt; gt; the background will be red.
gt; gt;
gt; gt; How do I get the conditional formatting to do this?
gt; gt;

Bonjour Bernard,

Thank you very much for your help with my Excel question. It worked
perfectly.
Another question, if you don't mind, and I hope I'm not imposing on your
time.
Let's say that the results of the cell are less than this month and year.
How could I get that to show up with whatever color I desire? Or, vice versa,
results are greater than current month and year?
Thank you again.

A la prochaine, Clyde Barney

quot;Bernard Liengmequot; wrote:

gt; Try =AND(MONTH(L55)=MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Clydequot; gt; wrote in message
gt; ...
gt; gt; My formula produces a dd-mmm-yyyy result which is correct.
gt; gt;
gt; gt; Cell L55 formula results a 17-May-2006
gt; gt;
gt; gt; Conditional formatting is set to: Formula is: =L55lt;=TODAY()
gt; gt;
gt; gt; With background pattern set to red.
gt; gt;
gt; gt; My problem is that the conditional formatting doesn't produce the results
gt; gt; I
gt; gt; desire which is that if the date in L55 falls within the month and year
gt; gt; that
gt; gt; the background will be red.
gt; gt;
gt; gt; How do I get the conditional formatting to do this?
gt; gt;
gt;
gt;
gt;

You can have up to 3 conditional formats in a cell without using VBA
Look for the Add button on the Conditional Formatting button
You could try, for example
cond 1: =AND(MONTH(L55)=MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
cond 2: =AND(MONTH(L55)lt;MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
cond 3: =AND(MONTH(L55)gt;MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Clydequot; gt; wrote in message
...
gt; Bonjour Bernard,
gt;
gt; Thank you very much for your help with my Excel question. It worked
gt; perfectly.
gt; Another question, if you don't mind, and I hope I'm not imposing on your
gt; time.
gt; Let's say that the results of the cell are less than this month and year.
gt; How could I get that to show up with whatever color I desire? Or, vice
gt; versa,
gt; results are greater than current month and year?
gt; Thank you again.
gt;
gt; A la prochaine, Clyde Barney
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; Try =AND(MONTH(L55)=MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
gt;gt; best wishes
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt; quot;Clydequot; gt; wrote in message
gt;gt; ...
gt;gt; gt; My formula produces a dd-mmm-yyyy result which is correct.
gt;gt; gt;
gt;gt; gt; Cell L55 formula results a 17-May-2006
gt;gt; gt;
gt;gt; gt; Conditional formatting is set to: Formula is: =L55lt;=TODAY()
gt;gt; gt;
gt;gt; gt; With background pattern set to red.
gt;gt; gt;
gt;gt; gt; My problem is that the conditional formatting doesn't produce the
gt;gt; gt; results
gt;gt; gt; I
gt;gt; gt; desire which is that if the date in L55 falls within the month and year
gt;gt; gt; that
gt;gt; gt; the background will be red.
gt;gt; gt;
gt;gt; gt; How do I get the conditional formatting to do this?
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
Hello Bernard,

Thank you again for your help.

I tried your suggestion and changed the date in the column that the L55
formula runs off of, but the results weren't right. I used a date of
22-Mar-2004 in cell K55 (L55 reference cell) but L55 didn't change to the
color I desired.

What am I doing wrong?

I'm sorry but I'm very new at this stuff.

quot;Bernard Liengmequot; wrote:

gt; You can have up to 3 conditional formats in a cell without using VBA
gt; Look for the Add button on the Conditional Formatting button
gt; You could try, for example
gt; cond 1: =AND(MONTH(L55)=MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
gt; cond 2: =AND(MONTH(L55)lt;MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
gt; cond 3: =AND(MONTH(L55)gt;MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Clydequot; gt; wrote in message
gt; ...
gt; gt; Bonjour Bernard,
gt; gt;
gt; gt; Thank you very much for your help with my Excel question. It worked
gt; gt; perfectly.
gt; gt; Another question, if you don't mind, and I hope I'm not imposing on your
gt; gt; time.
gt; gt; Let's say that the results of the cell are less than this month and year.
gt; gt; How could I get that to show up with whatever color I desire? Or, vice
gt; gt; versa,
gt; gt; results are greater than current month and year?
gt; gt; Thank you again.
gt; gt;
gt; gt; A la prochaine, Clyde Barney
gt; gt;
gt; gt; quot;Bernard Liengmequot; wrote:
gt; gt;
gt; gt;gt; Try =AND(MONTH(L55)=MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
gt; gt;gt; best wishes
gt; gt;gt; --
gt; gt;gt; Bernard V Liengme
gt; gt;gt; www.stfx.ca/people/bliengme
gt; gt;gt; remove caps from email
gt; gt;gt;
gt; gt;gt; quot;Clydequot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; My formula produces a dd-mmm-yyyy result which is correct.
gt; gt;gt; gt;
gt; gt;gt; gt; Cell L55 formula results a 17-May-2006
gt; gt;gt; gt;
gt; gt;gt; gt; Conditional formatting is set to: Formula is: =L55lt;=TODAY()
gt; gt;gt; gt;
gt; gt;gt; gt; With background pattern set to red.
gt; gt;gt; gt;
gt; gt;gt; gt; My problem is that the conditional formatting doesn't produce the
gt; gt;gt; gt; results
gt; gt;gt; gt; I
gt; gt;gt; gt; desire which is that if the date in L55 falls within the month and year
gt; gt;gt; gt; that
gt; gt;gt; gt; the background will be red.
gt; gt;gt; gt;
gt; gt;gt; gt; How do I get the conditional formatting to do this?
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Send me (my private email) the file
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Clydequot; gt; wrote in message
...
gt; Hello Bernard,
gt;
gt; Thank you again for your help.
gt;
gt; I tried your suggestion and changed the date in the column that the L55
gt; formula runs off of, but the results weren't right. I used a date of
gt; 22-Mar-2004 in cell K55 (L55 reference cell) but L55 didn't change to the
gt; color I desired.
gt;
gt; What am I doing wrong?
gt;
gt; I'm sorry but I'm very new at this stuff.
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; You can have up to 3 conditional formats in a cell without using VBA
gt;gt; Look for the Add button on the Conditional Formatting button
gt;gt; You could try, for example
gt;gt; cond 1: =AND(MONTH(L55)=MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
gt;gt; cond 2: =AND(MONTH(L55)lt;MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
gt;gt; cond 3: =AND(MONTH(L55)gt;MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
gt;gt; best wishes
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt; quot;Clydequot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Bonjour Bernard,
gt;gt; gt;
gt;gt; gt; Thank you very much for your help with my Excel question. It worked
gt;gt; gt; perfectly.
gt;gt; gt; Another question, if you don't mind, and I hope I'm not imposing on
gt;gt; gt; your
gt;gt; gt; time.
gt;gt; gt; Let's say that the results of the cell are less than this month and
gt;gt; gt; year.
gt;gt; gt; How could I get that to show up with whatever color I desire? Or, vice
gt;gt; gt; versa,
gt;gt; gt; results are greater than current month and year?
gt;gt; gt; Thank you again.
gt;gt; gt;
gt;gt; gt; A la prochaine, Clyde Barney
gt;gt; gt;
gt;gt; gt; quot;Bernard Liengmequot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Try =AND(MONTH(L55)=MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
gt;gt; gt;gt; best wishes
gt;gt; gt;gt; --
gt;gt; gt;gt; Bernard V Liengme
gt;gt; gt;gt; www.stfx.ca/people/bliengme
gt;gt; gt;gt; remove caps from email
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Clydequot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; My formula produces a dd-mmm-yyyy result which is correct.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Cell L55 formula results a 17-May-2006
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Conditional formatting is set to: Formula is: =L55lt;=TODAY()
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; With background pattern set to red.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; My problem is that the conditional formatting doesn't produce the
gt;gt; gt;gt; gt; results
gt;gt; gt;gt; gt; I
gt;gt; gt;gt; gt; desire which is that if the date in L55 falls within the month and
gt;gt; gt;gt; gt; year
gt;gt; gt;gt; gt; that
gt;gt; gt;gt; gt; the background will be red.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; How do I get the conditional formatting to do this?
gt;gt; gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
Hello Bernard,

I sent you my file at the stfx email addy without the truenorth because it
came back as undeliverable when I tried it with truenorth.

I hope you get my file.

Sincerely, Clyde

quot;Bernard Liengmequot; wrote:

gt; Send me (my private email) the file
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Clydequot; gt; wrote in message
gt; ...
gt; gt; Hello Bernard,
gt; gt;
gt; gt; Thank you again for your help.
gt; gt;
gt; gt; I tried your suggestion and changed the date in the column that the L55
gt; gt; formula runs off of, but the results weren't right. I used a date of
gt; gt; 22-Mar-2004 in cell K55 (L55 reference cell) but L55 didn't change to the
gt; gt; color I desired.
gt; gt;
gt; gt; What am I doing wrong?
gt; gt;
gt; gt; I'm sorry but I'm very new at this stuff.
gt; gt;
gt; gt; quot;Bernard Liengmequot; wrote:
gt; gt;
gt; gt;gt; You can have up to 3 conditional formats in a cell without using VBA
gt; gt;gt; Look for the Add button on the Conditional Formatting button
gt; gt;gt; You could try, for example
gt; gt;gt; cond 1: =AND(MONTH(L55)=MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
gt; gt;gt; cond 2: =AND(MONTH(L55)lt;MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
gt; gt;gt; cond 3: =AND(MONTH(L55)gt;MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
gt; gt;gt; best wishes
gt; gt;gt; --
gt; gt;gt; Bernard V Liengme
gt; gt;gt; www.stfx.ca/people/bliengme
gt; gt;gt; remove caps from email
gt; gt;gt;
gt; gt;gt; quot;Clydequot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Bonjour Bernard,
gt; gt;gt; gt;
gt; gt;gt; gt; Thank you very much for your help with my Excel question. It worked
gt; gt;gt; gt; perfectly.
gt; gt;gt; gt; Another question, if you don't mind, and I hope I'm not imposing on
gt; gt;gt; gt; your
gt; gt;gt; gt; time.
gt; gt;gt; gt; Let's say that the results of the cell are less than this month and
gt; gt;gt; gt; year.
gt; gt;gt; gt; How could I get that to show up with whatever color I desire? Or, vice
gt; gt;gt; gt; versa,
gt; gt;gt; gt; results are greater than current month and year?
gt; gt;gt; gt; Thank you again.
gt; gt;gt; gt;
gt; gt;gt; gt; A la prochaine, Clyde Barney
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Bernard Liengmequot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; Try =AND(MONTH(L55)=MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
gt; gt;gt; gt;gt; best wishes
gt; gt;gt; gt;gt; --
gt; gt;gt; gt;gt; Bernard V Liengme
gt; gt;gt; gt;gt; www.stfx.ca/people/bliengme
gt; gt;gt; gt;gt; remove caps from email
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;Clydequot; gt; wrote in message
gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt; My formula produces a dd-mmm-yyyy result which is correct.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Cell L55 formula results a 17-May-2006
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Conditional formatting is set to: Formula is: =L55lt;=TODAY()
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; With background pattern set to red.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; My problem is that the conditional formatting doesn't produce the
gt; gt;gt; gt;gt; gt; results
gt; gt;gt; gt;gt; gt; I
gt; gt;gt; gt;gt; gt; desire which is that if the date in L55 falls within the month and
gt; gt;gt; gt;gt; gt; year
gt; gt;gt; gt;gt; gt; that
gt; gt;gt; gt;gt; gt; the background will be red.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; How do I get the conditional formatting to do this?
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;