Help with conditional formating
 

Greetins,

I have a workbook that in column A the cell contents are populated with
dates, let's say A1= 07/01/07, A2=07/02/07, etc. I would like to do some
conditional formating that examines the date in each row, and if the value
is found to be either "Saturday" or "Sunday" (day of week) the whole
respective row will turn bold black and grayed background. I already know
you can use the function 'text(a1,"dddd") to get the day, it is the rest I
am lost on. Thanks for any help.

-lumpjaw

Help with conditional formating
 

Hi

Provided you have the Analysis Toolpak loaded, ToolsAddinsAnalysis
Toolpak, then
=WEEKDAY(A1,2)5
will be your test and set the format you require.

--
Regards

Roger Govier


"Lumpjaw" wrote in message
...
Greetins,

I have a workbook that in column A the cell contents are populated
with dates, let's say A1= 07/01/07, A2=07/02/07, etc. I would like to
do some conditional formating that examines the date in each row, and
if the value is found to be either "Saturday" or "Sunday" (day of
week) the whole respective row will turn bold black and grayed
background. I already know you can use the function 'text(a1,"dddd")
to get the day, it is the rest I am lost on. Thanks for any help.

-lumpjaw

Help with conditional formating
 

No need for the ATP. WEEKDAY is built-in. You were probably thinking about
WORKDAY.

--
Biff
Microsoft Excel MVP


"Roger Govier" wrote in message
...
Hi

Provided you have the Analysis Toolpak loaded, ToolsAddinsAnalysis
Toolpak, then
=WEEKDAY(A1,2)5
will be your test and set the format you require.

--
Regards

Roger Govier


"Lumpjaw" wrote in message
...
Greetins,

I have a workbook that in column A the cell contents are populated with
dates, let's say A1= 07/01/07, A2=07/02/07, etc. I would like to do some
conditional formating that examines the date in each row, and if the
value is found to be either "Saturday" or "Sunday" (day of week) the
whole respective row will turn bold black and grayed background. I
already know you can use the function 'text(a1,"dddd") to get the day, it
is the rest I am lost on. Thanks for any help.

-lumpjaw

Help with conditional formating
 

Yep, it was late (early)!!!!! Brain totally fuddled

--
Regards

Roger Govier


"T. Valko" wrote in message
...
No need for the ATP. WEEKDAY is built-in. You were probably thinking
about WORKDAY.

--
Biff
Microsoft Excel MVP


"Roger Govier" wrote in message
...
Hi

Provided you have the Analysis Toolpak loaded, ToolsAddinsAnalysis
Toolpak, then
=WEEKDAY(A1,2)5
will be your test and set the format you require.

--
Regards

Roger Govier


"Lumpjaw" wrote in message
...
Greetins,

I have a workbook that in column A the cell contents are populated
with dates, let's say A1= 07/01/07, A2=07/02/07, etc. I would like
to do some conditional formating that examines the date in each row,
and if the value is found to be either "Saturday" or "Sunday" (day
of week) the whole respective row will turn bold black and grayed
background. I already know you can use the function
'text(a1,"dddd") to get the day, it is the rest I am lost on.
Thanks for any help.

-lumpjaw