LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 77
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set NETWORKDAYS to regard friday and saturday as weekend Shay.C. Excel Worksheet Functions 2 April 13th 10 05:13 PM
Determining the Sunday date of the third "full" weekend of a month Bob Excel Worksheet Functions 25 September 13th 09 07:26 PM
Friday as weekend instead of Saturday & Sunday Naushad Excel Worksheet Functions 3 March 14th 09 08:22 AM
I want a particular cell to know the upcoming Saturday date. Mae Excel Discussion (Misc queries) 6 October 24th 07 08:37 PM
Determine next Saturday in calendar based on date in a cell ann New Users to Excel 4 October 9th 06 05:09 PM


All times are GMT +1. The time now is 05:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"