Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Can I extend conditional fromatting?

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I work in a small tool hire shop and we have dificulty in tracking the dates that machines are hired for. I know a little about excel and I can create a list of dates for each machine but others in the shop are not computer literate.

    Can I create a macro that can be run by anybody to enter the machine number and dates to he hired. And create a chart of some kind to show when an item is out on hire.

    The problem is that notes are left for me to input and these notes sometimes get lost.

    Derek Kindly informed me about conditional formatting and this worked to a certain extent in that it will colour the cells up until a return date and mark the return date.

    The problem is I am trying to set up a monthly chart to show when machines are out on hire.

    If somebody wants to hire a machine for 3 days at the end of the month, then the conditional formating shows the machine as being on hire from the start of the month to the return date.

    Some machines are hired for only 1 day some for a week at a time.

    Can this be done or am I asking for the impossible.

    Thanks in advance for help offered.

    Gary

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Gary,

    you may need to post some concrete examples of your current data ie :

    Column A (dates)

    14/7/2001
    15/8/2001
    17/5/2001
    15/8/2001
    17/5/2001
    15/8/2001
    17/5/2001

    Column B (machines)

    SAW2
    SAW3
    SAW3
    PLANE1
    STEAMER
    PLANE2

    "How can I show dates less than 20 days from *whenever* in column C"

    etc etc

    [describing our different work situations often doesn't translate as easy as the language of Excel which is columns, rows, data and a goal..... a language we all speak !!]

    Flagged you up to the top of the list also

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Gary

    I have been working on your problem and have developed a spreadsheet which should be able to do what you want. I have e-mailed it to you
    regards
    Derek

    [ This Message was edited by: Derek on 2002-03-26 03:21 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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