Groups | Search | Server Info | Login | Register
Groups > comp.sys.acorn.misc > #6084
| Path | csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!de-l.enfer-du-nord.net!feeder1.enfer-du-nord.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail |
|---|---|
| From | Dave Symes <dave@triffid.co.uk> |
| Newsgroups | comp.sys.acorn.misc |
| Subject | Re: Eureka spreadsheet question. |
| Date | Wed, 15 Aug 2012 07:11:29 +0100 |
| Organization | Triffids Leg Press |
| Lines | 40 |
| Message-ID | <52bf7d76dddave@triffid.co.uk> (permalink) |
| References | <52bb25d3c0dave@triffid.co.uk> <52bb2c6f3bbrian@bdebenham.co.uk> <52bb5b9fc3dave@triffid.co.uk> <52bf3f2945dave@triffid.co.uk> <26364ebf52.david@david.wisnia.net> |
| X-Trace | individual.net 1s2VS6mwjv9+EFN4d+UX9QsMC4MVI6vzCHoCU/3pjvuJH1qVzfTQ60PRU2ndESjVOg |
| X-Orig-Path | triffid.co.uk!dave |
| Cancel-Lock | sha1:fVnvPKKKgG12ViGQX/9tKk4hVi4= |
| User-Agent | Pluto/3.04e (RISC-OS/6.20) NewsHound/v1.52-32 |
| Xref | csiph.com comp.sys.acorn.misc:6084 |
Show key headers only | View raw
In article <26364ebf52.david@david.wisnia.net>,
Dave Wisnia at home <david@wisnia.net> wrote:
> In message <52bf3f2945dave@triffid.co.uk>
> Dave Symes <dave@triffid.co.uk> wrote:
>
[Snippy]
> > My next question related to this matter is probably bordering on the
> > silly, however, if I don't ask I'll never know. ;-)
> > Are there any methods in a sheet whereby when the debt becomes aged of
> > n number of days, the answer in the cell or the cell/colour
> > automatically changes.
> > For example: When the age become 31 days, then the cell flashes or
> > maybe changes colour to Red.
> > Thanks
> > Dave
> Hello Dave
> If the number 31 is in cell D5 for example, in the cell next to the
> answer (E5) put =if(D5>31,"OVERDUE!","").
> Can't answer re background colour change - this will probably need a
> macro.
Thanks for the thought...
But.
I already have an array formula in the form of...
{=IF(Dll>=31,"Debtor",IF(D11<31,"Okay"))}
Dave
--
Dave Triffid
Back to comp.sys.acorn.misc | Previous | Next — Previous in thread | Next in thread | Find similar
Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-06 20:49 +0100
Re: Eureka spreadsheet question. Dave Wisnia at home <david@wisnia.net> - 2012-08-06 21:53 +0100
Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-07 06:48 +0100
Re: Eureka spreadsheet question. Dave Wisnia at home <david@wisnia.net> - 2012-08-07 09:02 +0100
Re: Eureka spreadsheet question. M Harding <riscos@mdharding.org.uk> - 2012-08-07 11:22 +0100
Re: Eureka spreadsheet question. Dave Wisnia at home <david@wisnia.net> - 2012-08-07 12:33 +0100
Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-07 20:04 +0100
Re: Eureka spreadsheet question. Brian Debenham <brian@bdebenham.co.uk> - 2012-08-06 22:01 +0100
Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-07 06:37 +0100
Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-14 19:51 +0100
Re: Eureka spreadsheet question. Dave Wisnia at home <david@wisnia.net> - 2012-08-14 22:35 +0100
Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-15 07:11 +0100
Re: Eureka spreadsheet question. Tony Moore <old_coaster@yahoo.co.uk> - 2012-08-15 10:42 +0000
Re: Eureka spreadsheet question. Alan Calder <alan_calder@o2.co.uk> - 2012-08-15 13:34 +0100
Re: Eureka spreadsheet question. John Bryan <john@bryan86.fsnet.co.uk> - 2012-08-15 14:30 +0100
Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-15 21:43 +0100
Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-18 19:06 +0100
Re: Eureka spreadsheet question. Julian Fry <julainfry@tiscali.co.uk> - 2012-08-19 13:18 +0100
Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-19 15:16 +0100
Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-19 15:18 +0100
csiph-web