Google spreadsheet stuff

[Howard]

Let's say I have a system where somebody pays me $1 for a month's worth of web hosting (or whatever). Right now I'm doing it manually, where I record the date of purchase in one cell and the expiry date in an adjacent cell.

What's the easiest way for me to set up a cell to tell me immediately whether that month of service is expired or not?

The spreadsheet is currently in a Google Doc thingy.

 

[Patranus]

Conditional Formatting

Make the background red if expired.

 

[Howard]

I need a comparator of sorts. If I just highlight some text, I will still need to check whether the service is expired or not. I want something to compare for me automatically so I can scan briefly and see e.g. if there is any red as opposed to green.

 

[Howard]

🙁

 

[SSUSeaWolf]

I need a comparator of sorts. If I just highlight some text, I will still need to check whether the service is expired or not. I want something to compare for me automatically so I can scan briefly and see e.g. if there is any red as opposed to green.

Conditional Formatting

Make the background red if expired.

 

[Gooberlx2]

Yeah, it doesn't look like google docs conditional formatting allows for other cell references. You probably have to write a script (which apparently google docs does support now, which is rad).

edit: What you could do is have a third column that displays an 'X' or something when comparing the first two.
edit2: Something like:

 A		 B		 C
1 Purchase Date	 Expire Date	 Expired?
2 2/1/2011	 2/11/2011	 X
3 2/18/2011	 2/28/2011	 <blank>

Column B (assuming 10 day expiration):
=A2+10

Column C:
=IF(B2-A2 < Today()-A2, "X", "")

...or <= I guess depending on whether expiration date is day of, day after, etc...

 

[rcpratt]

Conditional formatting for IF(CURRENTDATE>EXPIRYDATE), for Excel at least. I don't know what Google Docs can do.

 

[BoomerD]

http://www.google.com/support/forum/p/Google+Docs/thread?tid=1e882a2de772c167&hl=en

http://www.google.com/support/forum/p/Google+Docs/thread?tid=2b1a6b691505489e&hl=en

You may have to break down and buy Excel to get what you want in your spreadsheets...MAYBE Open Office Calc will do what you want...not sure.

 

[Numenorean]

Step 1: Purchase a real spreadsheet program.

Step 2: Use conditional formatting. For example, make the background red if it's expired.

Step 3: .....

Step 4: PROFIT!

 

[sdifox]

just add a third column giving you 1 or 0 based on condition then do conditional on that column.

 

[Howard]

figured it out

thanks guys