Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.filemaker > #1141
| From | Martin Τrautmann <t-usenet@gmx.net> |
|---|---|
| Newsgroups | comp.databases.filemaker |
| Subject | Re: Conditional formating |
| Date | 2013-01-17 09:20 +0000 |
| Organization | slrn user |
| Message-ID | <slrnkffgio.t3s.t-usenet@ID-685.user.individual.de> (permalink) |
| References | <deeed578-cc78-4c2b-96e7-e24f3218eda4@googlegroups.com> |
On Thu, 17 Jan 2013 01:00:03 -0800 (PST), JayBee wrote:
> Hi
>
> I was wondering if Conditional formating as in MS Excel is possible in Filemaker.
>
> For example when I used it in Excel it was:
> If these cells are not empty then please make fill colour grey and text colour red.
>
> For FM I have been asked if one checkbox field is clicked make it's fill colour red and if another checkbox is clicked make it's fill colour yellow ?!
I don't know a fill color formatting, but you may add a container field
behind the data entry field which holds different images - for you, this
could be one pixel graphics, zoomed to field extension.
Add e.g. a field "backgrounds" of type container, global storage, several
repetitions, add color images to repetition 1, 2, 3, ...
And use another calculation field with result container and compute
case (cell1 = "", getrepetition(backgrounds,2),
cell3=1, getrepetition(backgrounds,3),
"")
- Martin
Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Conditional formating JayBee <Jennifer_Beecroft@hotmail.com> - 2013-01-17 01:00 -0800
Re: Conditional formating Martin Τrautmann <t-usenet@gmx.net> - 2013-01-17 09:20 +0000
Re: Conditional formating clkaufmann@gmx.ch (Christoph Kaufmann) - 2013-01-17 11:48 +0100
Re: Conditional formating Martin Τrautmann <t-usenet@gmx.net> - 2013-01-17 11:07 +0000
Re: Conditional formating JayBee <Jennifer_Beecroft@hotmail.com> - 2013-01-18 08:57 -0800
csiph-web