date conditional formatting
Thank you Frank for your brilliance.
Thank you tjtjjtjt for the question. Exactly what I needed to know.
lolan7
"tjtjjtjt" wrote:
Thanks, Frank. I'd found WEEKDAY, but I had no clue on how to set it up in the Conditional Formatting Box.
tj
"Frank Kabel" wrote:
Hi
try the following:
- select cells A2:A165
- goto the conditional format dialog
- enter the following formula
=WEEKDAY(A2,2)=6
- choose a format
--
Regards
Frank Kabel
Frankfurt, Germany
"tjtjjtjt" schrieb im Newsbeitrag
...
I have consecutive dates arranged in A2:A165.
What I would like to do is Conditionally Format only weekend dates to
shade yellow. Can this be done? I suspect there is an 'Is Formula'
solution out there, but I haven't been able to do it yet. Any help
would be appreciated.
tj
|