Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell colour chg when formula results equal a weekend day, i.e., "Saturday" and a date that falls on a Saturday?
Hope the subject line isn't totally muddy <g.
I have a spreadsheet that is super. The only trouble is that weekends aren't differentiated from weekdays in any way. Since the spreadsheet contains a macro for the user to select the starting date and then the rest of the spreadsheet is then populated for 3 weeks following that date, Saturday and Sunday always fall on different cells at any given time. Also, affected cells may say "Saturday" or "Sunday" but there is actually only a formula in any of them. The only exception is the very first cell which is the initial one the macro dumps to. So the first might read "Friday" if I choose today's date in the prompt box, but all the rest of the days of the weeks shown display the dates according to appropriate variations of this formula: =IF(A2<"",A2+1,"") In today's example, this actual formula above displays "Saturday". The cell immediately below displays "Sep.17.2005". I'm hoping that since it's the same type formatting issue, hopefully resolving cell colouring for the text "Saturday" issue will lead me to figure out how to do so for dates that fall on weekends. Is there a way to do this cell colour change under these conditions? I'm in favour of conditional formatting, but couldn't figure out how to do so because of the fact above that no actual text is found where all the Saturdays and Sundays are, only the formula. Tx.! :oD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set NETWORKDAYS to regard friday and saturday as weekend | Excel Worksheet Functions | |||
Determining the Sunday date of the third "full" weekend of a month | Excel Worksheet Functions | |||
Friday as weekend instead of Saturday & Sunday | Excel Worksheet Functions | |||
I want a particular cell to know the upcoming Saturday date. | Excel Discussion (Misc queries) | |||
Determine next Saturday in calendar based on date in a cell | New Users to Excel |