• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

A court booking system

kevinonearth

kevinonearth

Member
Hi,

I am a member of a tennis club.

We are looking at creating a very simple tennis court booking system.


Members will arrive in to the club sign in to the tennis club computer and sign in to a court.


There are 9 courts. All games begin on the half hour or hour and courts must be vacated after 1 hour of play.

All I want to be able to do is say if a cell is not empty then apply conditional formatting to that cell and copy the contents and formatting of that cell to the next cell.


So if a person books at 18h00 on Monday then cell B2 and cell C2 are formatted with red fill and yellow text.

https://dl.dropbox.com/u/90990975/court%20booking.xlsx
 
Hi ,


I personally can certainly help ; I would like to help too ; but not the way you want , yesterday. Sorry.


If you can wait till tomorrow morning , I can try.


Narayan
 
Good day kevinonearth


You can not have people posting their files to your posted link.

Not sure what problems you are having but I opened NARAYANK991s posting with no problems, very nice piece of conditional formating
 
Hi ,


I do not know what the problem can be ; however , posting the file to your link is not possible , since when I click on your link , it directly downloads your file ; it does not open Dropbox.


Can you download from Google Docs ? If so , here is the link for it :


https://docs.google.com/open?id=0B0KMpuzr3MTVczhteG9ScmhEOFU


Narayan
 
Hi, did your Excel work fine. Have you tried looking for a free booking system that sites like MyCourts, TennisEarth and others provide?
 
You must log in or register to reply here.
Back
Top