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>
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

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