Re: Conditional Formatting For WEEKDAY()

Tech-Archive recommends: Fix windows errors by optimizing your registry

In article <jemcgimpsey-E00038.12492218062005@xxxxxxxxxxxxxxxxxxxx>,
JE McGimpsey <jemcgimpsey@xxxxxxxx> wrote:

>Using the entire column in your formula won't work - it will create an
>error, so the CF isn't applied. Errors in CF evaluations don't cause any
>error messages. When you don't see what you expect, try entering the
>formula in the work*** to see if it results in a TRUE/FALSE (or
>non-zero/zero) answer.

You are (as always) correct, but I didn't get that out of the online Help.
And, not having this tutelage, I think I actually have conditionally
formatted a named range by highlighting it and just inserting my formula.
IS WEEKDAY a special a case of some kind ?


>CF1: Formula is =WEEKDAY(A1,3)>4
>Format1: <your color>
>XL will adjust the cell references for you in the other cells. If A2
>were the active cell, you'd use A2 instead.

Perfect -- as always. (Envious sigh supplied by the undersigned.)

>Note that using the second argument for WEEKDAY requires only one
>condition.

Oh, of course. Obvious. I mean, if one is clever enough to note that the
"3" signal makes Monday = 0, so the weekend is >4, it's open-and shut. (I
shall sign off before sobbing.)

-- Will --





.

Quantcast