L
Lumpjaw
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
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