Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formating | Excel Discussion (Misc queries) | |||
conditional formating with len | Excel Discussion (Misc queries) | |||
Conditional formating | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating | Excel Programming |