+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Conditional Formatting in Technical; One for the Excel gurus. I've been using some functions in Excel to work out which days of a range ...
  1. #1

    garethedmondson's Avatar
    Join Date
    Oct 2008
    Location
    Gowerton, Swansea
    Posts
    2,309
    Thank Post
    973
    Thanked 326 Times in 194 Posts
    Blog Entries
    11
    Rep Power
    170

    Conditional Formatting

    One for the Excel gurus. I've been using some functions in Excel to work out which days of a range of days are weekends (networkdays function). It is very good and one I hadn't seen before.

    How can someone help me with the following.

    I have a sheet which represents the month of May. It is formatted into a range of cells representing the days of the month.

    Row 1 (cells 2 to 32) are the dates.

    On another sheet, I have a cell where I can put a start date and another cell where I can put an end date.

    Now depending on these dates I put in, how can I get the cells on the month sheet to either colour themselves or have a text label entered into the cell?

    Does that make sense?

    So it works kind of like a diary. Example:

    Start Date: 01/05/2010
    End Date : 14/05/2010
    Total of days: 13

    So on the diary page, it colours in Cells A2:A15 in Red.

    Gareth

  2. #2

    Join Date
    Apr 2007
    Location
    Birmingham
    Posts
    146
    Thank Post
    7
    Thanked 45 Times in 39 Posts
    Rep Power
    23
    I think I understand what you want

    Sadly, conditional formatting (at least in 2003) can't refer to cells on another sheet, so i had to have two hidden columns.

    Hope its ok.
    Attached Files Attached Files



SHARE:
+ Post New Thread

Similar Threads

  1. conditional format in php
    By featured_spectre in forum Coding
    Replies: 17
    Last Post: 6th January 2010, 12:21 AM
  2. [MS Office - 2003] Conditional Formatting
    By stevenwba in forum Office Software
    Replies: 3
    Last Post: 17th December 2009, 03:28 PM
  3. [MS Office - 2003] Excel - Conditional Formatting using formula
    By park_bench in forum Office Software
    Replies: 1
    Last Post: 10th June 2009, 03:25 PM
  4. Conditional formatting help needed
    By Jobos in forum How do you do....it?
    Replies: 3
    Last Post: 3rd June 2008, 02:58 PM
  5. Help with conditional formatting
    By randle in forum Windows
    Replies: 3
    Last Post: 25th October 2007, 02:20 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •