Results 1 to 14 of 14

excel if/then functions with dates and colour

Threaded View

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    The Hague
    MS-Off Ver
    Excel 20037
    Posts
    10

    excel if/then functions with dates and colour

    Hello, this will be mine first post on this forum, and I think not the last one.

    The following is driving me crazy.
    I have a spreadsheet that shows the planning and availability of demo systems for a whole year.
    There is a start date (cell A2) and an end date (cell B2) that I manual type in.
    In Row 1 from cell C1 - IV1) I have all the dates of one year.
    If I fill out the dates I colour the cells in the row manual.

    Now I am looking for a formula that colours these cells automatic when I type in the dates.

    Thanks.

    Prins
    Last edited by Prins; 11-07-2012 at 09:47 AM.

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1