Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.sys.acorn.misc > #6095
| From | Alan Calder <alan_calder@o2.co.uk> |
|---|---|
| Newsgroups | comp.sys.acorn.misc |
| Subject | Re: Eureka spreadsheet question. |
| Date | 2012-08-15 13:34 +0100 |
| Organization | None |
| Message-ID | <52bfa08f99alan_calder@o2.co.uk> (permalink) |
| References | (2 earlier) <52bb5b9fc3dave@triffid.co.uk> <52bf3f2945dave@triffid.co.uk> <26364ebf52.david@david.wisnia.net> <52bf7d76dddave@triffid.co.uk> <fa4196bf52.old_coaster@old_coaster.yahoo.co.uk> |
In article <fa4196bf52.old_coaster@old_coaster.yahoo.co.uk>,
Tony Moore <old_coaster@yahoo.co.uk> wrote:
> 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'.
Eureka has a Number Format option that allows negative numbers to be shown
in red. Set up to do this as £s but easily edited. Could this formatting
option get what DS is wanting?
Alan
[Snip]
--
Alan Calder, Milton Keynes, UK.
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