1. Select the cells to be formatted (say row A in this example)
2. Choose FormatConditional 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: =$A175
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:
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

"Kirk" wrote:

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

"Sloth" wrote:

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).

"Kirk" wrote:

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)
="WEEKNUM($C$4,1) = WEEKNUM($A$1,1)" with no results
C4 is the current cell, A1 is a refernce cell with TODAY().



--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

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