software

I'm trying to conditional format to highlight a date cell if its in the
current week.

I know whow to use WEEKNUM to check a week's number (1-53). I did check to
make sure the Analyst Pack was loaded.

The challenge I have is getting conditional formatting using formulas to
check the current cell

I'm trying the following formula: (In Conditional Formatting)
=quot;WEEKNUM($C$4,1) = WEEKNUM($A$1,1)quot; with no results
C4 is the current cell, A1 is a refernce cell with TODAY().Remove the quotes and it should work. Quotes usually appear if you forget
the first '='. I am not sure why, they just mess things up.

I don't use the analysis toolpak, so I can't tell if the problem is with the
WEEKNUM function (I doubt it is though).

quot;Kirkquot; wrote:

gt; I'm trying to conditional format to highlight a date cell if its in the
gt; current week.
gt;
gt; I know whow to use WEEKNUM to check a week's number (1-53). I did check to
gt; make sure the Analyst Pack was loaded.
gt;
gt; The challenge I have is getting conditional formatting using formulas to
gt; check the current cell
gt;
gt; I'm trying the following formula: (In Conditional Formatting)
gt; =quot;WEEKNUM($C$4,1) = WEEKNUM($A$1,1)quot; with no results
gt; C4 is the current cell, A1 is a refernce cell with TODAY().
gt;

=A2-WEEKDAY(A2)=TODAY()-WEEKDAY(TODAY())

Might be more usefull, because it only includes days of the current week in
the current year. For instance 1/1/2003 and 1/1/2005 both return a WEEKNUM
of 1 don't they? With my function though, it isn't in the same week. Or is
that what you wanted? The function above assumes a week starts on Sunday.

Depending on what you want, this might not be as usefull because 12/31/2004
(a friday) would be included in the same week as 1/1/2005 (a saturday).

quot;Slothquot; wrote:

gt; Remove the quotes and it should work. Quotes usually appear if you forget
gt; the first '='. I am not sure why, they just mess things up.
gt;
gt; I don't use the analysis toolpak, so I can't tell if the problem is with the
gt; WEEKNUM function (I doubt it is though).
gt;
gt; quot;Kirkquot; wrote:
gt;
gt; gt; I'm trying to conditional format to highlight a date cell if its in the
gt; gt; current week.
gt; gt;
gt; gt; I know whow to use WEEKNUM to check a week's number (1-53). I did check to
gt; gt; make sure the Analyst Pack was loaded.
gt; gt;
gt; gt; The challenge I have is getting conditional formatting using formulas to
gt; gt; check the current cell
gt; gt;
gt; gt; I'm trying the following formula: (In Conditional Formatting)
gt; gt; =quot;WEEKNUM($C$4,1) = WEEKNUM($A$1,1)quot; with no results
gt; gt; C4 is the current cell, A1 is a refernce cell with TODAY().
gt; gt;

Thanks. This wasn't the problem. I'm thinking WEEKNUM won't work in
Conditional Formatting. If someone can help there. (I may need to set up
dummy cells with the WEEKNUM values and compare them to each other.

Kirk

quot;Slothquot; wrote:

gt; Remove the quotes and it should work. Quotes usually appear if you forget
gt; the first '='. I am not sure why, they just mess things up.
gt;
gt; I don't use the analysis toolpak, so I can't tell if the problem is with the
gt; WEEKNUM function (I doubt it is though).
gt;
gt; quot;Kirkquot; wrote:
gt;
gt; gt; I'm trying to conditional format to highlight a date cell if its in the
gt; gt; current week.
gt; gt;
gt; gt; I know whow to use WEEKNUM to check a week's number (1-53). I did check to
gt; gt; make sure the Analyst Pack was loaded.
gt; gt;
gt; gt; The challenge I have is getting conditional formatting using formulas to
gt; gt; check the current cell
gt; gt;
gt; gt; I'm trying the following formula: (In Conditional Formatting)
gt; gt; =quot;WEEKNUM($C$4,1) = WEEKNUM($A$1,1)quot; with no results
gt; gt; C4 is the current cell, A1 is a refernce cell with TODAY().
gt; gt;

PERFECT !!!! Thank you so much! Works perfectly!
And I didn't even think of what year the week is in. My conditional
formatting function was to grey out dates that were past, highlight a cell in
red that's today, and higlight a cell in yellow for what dates are this week!
I got the first two, but coouldn't figure out the 3rd.

V/R, Kirk

quot;Slothquot; wrote:

gt; =A2-WEEKDAY(A2)=TODAY()-WEEKDAY(TODAY())
gt;
gt; Might be more usefull, because it only includes days of the current week in
gt; the current year. For instance 1/1/2003 and 1/1/2005 both return a WEEKNUM
gt; of 1 don't they? With my function though, it isn't in the same week. Or is
gt; that what you wanted? The function above assumes a week starts on Sunday.
gt;
gt; Depending on what you want, this might not be as usefull because 12/31/2004
gt; (a friday) would be included in the same week as 1/1/2005 (a saturday).
gt;
gt; quot;Slothquot; wrote:
gt;
gt; gt; Remove the quotes and it should work. Quotes usually appear if you forget
gt; gt; the first '='. I am not sure why, they just mess things up.
gt; gt;
gt; gt; I don't use the analysis toolpak, so I can't tell if the problem is with the
gt; gt; WEEKNUM function (I doubt it is though).
gt; gt;
gt; gt; quot;Kirkquot; wrote:
gt; gt;
gt; gt; gt; I'm trying to conditional format to highlight a date cell if its in the
gt; gt; gt; current week.
gt; gt; gt;
gt; gt; gt; I know whow to use WEEKNUM to check a week's number (1-53). I did check to
gt; gt; gt; make sure the Analyst Pack was loaded.
gt; gt; gt;
gt; gt; gt; The challenge I have is getting conditional formatting using formulas to
gt; gt; gt; check the current cell
gt; gt; gt;
gt; gt; gt; I'm trying the following formula: (In Conditional Formatting)
gt; gt; gt; =quot;WEEKNUM($C$4,1) = WEEKNUM($A$1,1)quot; with no results
gt; gt; gt; C4 is the current cell, A1 is a refernce cell with TODAY().
gt; gt; gt;

Hi

this is what i also want but I want it to shade the whole row. Does anyone
know how to do that?
Thanks
Debbie

quot;Kirkquot; wrote:

gt; Thanks. This wasn't the problem. I'm thinking WEEKNUM won't work in
gt; Conditional Formatting. If someone can help there. (I may need to set up
gt; dummy cells with the WEEKNUM values and compare them to each other.
gt;
gt; Kirk
gt;
gt; quot;Slothquot; wrote:
gt;
gt; gt; Remove the quotes and it should work. Quotes usually appear if you forget
gt; gt; the first '='. I am not sure why, they just mess things up.
gt; gt;
gt; gt; I don't use the analysis toolpak, so I can't tell if the problem is with the
gt; gt; WEEKNUM function (I doubt it is though).
gt; gt;
gt; gt; quot;Kirkquot; wrote:
gt; gt;
gt; gt; gt; I'm trying to conditional format to highlight a date cell if its in the
gt; gt; gt; current week.
gt; gt; gt;
gt; gt; gt; I know whow to use WEEKNUM to check a week's number (1-53). I did check to
gt; gt; gt; make sure the Analyst Pack was loaded.
gt; gt; gt;
gt; gt; gt; The challenge I have is getting conditional formatting using formulas to
gt; gt; gt; check the current cell
gt; gt; gt;
gt; gt; gt; I'm trying the following formula: (In Conditional Formatting)
gt; gt; gt; =quot;WEEKNUM($C$4,1) = WEEKNUM($A$1,1)quot; with no results
gt; gt; gt; C4 is the current cell, A1 is a refernce cell with TODAY().
gt; gt; gt;


1. Select the cells to be formatted (say row A in this example)
2. Choose Formatgt;Conditional Formatting...
3. From the first drop-down list, choose Formula Is
4. In the text box, enter a formula that refers to the active cell in
the selection.
For example: =$A1gt;75
5. Click the Format button.
6. Select the formatting options, click OK
7. Click OK
Make sure the colmun refence is preceded with the $ sign

Phippsy;310492 Wrote:
gt; Hi
gt;
gt; this is what i also want but I want it to shade the whole row. Does
gt; anyone
gt; know how to do that?
gt; Thanks
gt; Debbie
gt;
gt; quot;Kirkquot; wrote:
gt;
gt; gt; Thanks. This wasn't the problem. I'm thinking WEEKNUM won't work
gt; in
gt; gt; Conditional Formatting. If someone can help there. (I may need to
gt; set up
gt; gt; dummy cells with the WEEKNUM values and compare them to each other.
gt; gt;
gt; gt; Kirk
gt; gt;
gt; gt; quot;Slothquot; wrote:
gt; gt;
gt; gt; gt; Remove the quotes and it should work. Quotes usually appear if you
gt; forget
gt; gt; gt; the first '='. I am not sure why, they just mess things up.
gt; gt; gt;
gt; gt; gt; I don't use the analysis toolpak, so I can't tell if the problem is
gt; with the
gt; gt; gt; WEEKNUM function (I doubt it is though).
gt; gt; gt;
gt; gt; gt; quot;Kirkquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I'm trying to conditional format to highlight a date cell if its
gt; in the
gt; gt; gt; gt; current week.
gt; gt; gt; gt;
gt; gt; gt; gt; I know whow to use WEEKNUM to check a week's number (1-53). I
gt; did check to
gt; gt; gt; gt; make sure the Analyst Pack was loaded.
gt; gt; gt; gt;
gt; gt; gt; gt; The challenge I have is getting conditional formatting using
gt; formulas to
gt; gt; gt; gt; check the current cell
gt; gt; gt; gt;
gt; gt; gt; gt; I'm trying the following formula: (In Conditional Formatting)
gt; gt; gt; gt; =quot;WEEKNUM($C$4,1) = WEEKNUM($A$1,1)quot; with no results
gt; gt; gt; gt; C4 is the current cell, A1 is a refernce cell with TODAY().
gt; gt; gt; gt;--
Pecoflyer

Cheers -
*'Membership is free' (www.thecodecage.com)* amp; allows file
upload -gt;faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: www.thecodecage.com/forumz/member.php?userid=14
View this thread: www.thecodecage.com/forumz/sh...ad.php?t=86802Brilliant thanks

quot;Pecoflyerquot; wrote:

gt;
gt; 1. Select the cells to be formatted (say row A in this example)
gt; 2. Choose Formatgt;Conditional Formatting...
gt; 3. From the first drop-down list, choose Formula Is
gt; 4. In the text box, enter a formula that refers to the active cell in
gt; the selection.
gt; For example: =$A1gt;75
gt; 5. Click the Format button.
gt; 6. Select the formatting options, click OK
gt; 7. Click OK
gt; Make sure the colmun refence is preceded with the $ sign
gt;
gt; Phippsy;310492 Wrote:
gt; gt; Hi
gt; gt;
gt; gt; this is what i also want but I want it to shade the whole row. Does
gt; gt; anyone
gt; gt; know how to do that?
gt; gt; Thanks
gt; gt; Debbie
gt; gt;
gt; gt; quot;Kirkquot; wrote:
gt; gt;
gt; gt; gt; Thanks. This wasn't the problem. I'm thinking WEEKNUM won't work
gt; gt; in
gt; gt; gt; Conditional Formatting. If someone can help there. (I may need to
gt; gt; set up
gt; gt; gt; dummy cells with the WEEKNUM values and compare them to each other.
gt; gt; gt;
gt; gt; gt; Kirk
gt; gt; gt;
gt; gt; gt; quot;Slothquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Remove the quotes and it should work. Quotes usually appear if you
gt; gt; forget
gt; gt; gt; gt; the first '='. I am not sure why, they just mess things up.
gt; gt; gt; gt;
gt; gt; gt; gt; I don't use the analysis toolpak, so I can't tell if the problem is
gt; gt; with the
gt; gt; gt; gt; WEEKNUM function (I doubt it is though).
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Kirkquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I'm trying to conditional format to highlight a date cell if its
gt; gt; in the
gt; gt; gt; gt; gt; current week.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I know whow to use WEEKNUM to check a week's number (1-53). I
gt; gt; did check to
gt; gt; gt; gt; gt; make sure the Analyst Pack was loaded.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; The challenge I have is getting conditional formatting using
gt; gt; formulas to
gt; gt; gt; gt; gt; check the current cell
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I'm trying the following formula: (In Conditional Formatting)
gt; gt; gt; gt; gt; =quot;WEEKNUM($C$4,1) = WEEKNUM($A$1,1)quot; with no results
gt; gt; gt; gt; gt; C4 is the current cell, A1 is a refernce cell with TODAY().
gt; gt; gt; gt; gt;
gt;
gt;
gt; --
gt; Pecoflyer
gt;
gt; Cheers -
gt; *'Membership is free' (www.thecodecage.com)* amp; allows file
gt; upload -gt;faster and better answers
gt;
gt; *Adding your XL version* to your post helps finding solution faster
gt; ------------------------------------------------------------------------
gt; Pecoflyer's Profile: www.thecodecage.com/forumz/member.php?userid=14
gt; View this thread: www.thecodecage.com/forumz/sh...ad.php?t=86802
gt;
gt;