Groups | Search | Server Info | Keyboard shortcuts | Login | Register

Groups > comp.sys.acorn.misc > #6091

Re: Eureka spreadsheet question.

Show all headers | View raw

On 15 Aug 2012, Dave Symes <dave@triffid.co.uk> wrote:
> 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:

[snip]

> > > 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.
>
> > 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"))}

I know nothing about Eureka, but PipeDream allows a negative velue to be
displayed in red. This could be applied to a cell showing '30 - age'.

Tony

Back to comp.sys.acorn.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

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