Prev: Increment Value By 1 Each Time Spreadsheet is Opened
Next: Office Password Unlocker
From: Black Iccy on 3 Jun 2010 22:20
On Thu, 3 Jun 2010 17:31:02 -0700, FSt1 <FSt1(a)discussions.microsoft.com>
wrote:

>
>but what if the value is zero?? the above doesn't address that.

So, extend the set of definitions.
See the "Add" button?
The one at the bottom of the panel?



>how about......
>cell value is.... greater than or equal to......0........pick green
>you can format the entire column all a once. not really recommended that you
>do the "entire" column, just enough to cover your data.
>read up on CF in 07. that i'm not up on yet.


From: FSt1 on 3 Jun 2010 23:49
good point but i prefere to limit the number of CF's as much as possible.
see my suggestion.
i would guess it would be user preference.

Regards
FSt1


"Black Iccy" wrote:

> On Thu, 3 Jun 2010 17:31:02 -0700, FSt1 <FSt1(a)discussions.microsoft.com>
> wrote:
>
> >
> >but what if the value is zero?? the above doesn't address that.
>
> So, extend the set of definitions.
> See the "Add" button?
> The one at the bottom of the panel?
>
>
>
> >how about......
> >cell value is.... greater than or equal to......0........pick green
> >you can format the entire column all a once. not really recommended that you
> >do the "entire" column, just enough to cover your data.
> >read up on CF in 07. that i'm not up on yet.
>
>
> .
>
From: Black Iccy on 4 Jun 2010 00:44
On Thu, 3 Jun 2010 20:49:01 -0700, FSt1 <FSt1(a)discussions.microsoft.com>
wrote:

>good point but i prefere to limit the number of CF's as much as possible.
>see my suggestion.
>i would guess it would be user preference.

Ummm, but you can only ever set 3 parameters/choices (in Office/Excel 97)
... max .. ever. How much of a limit makes you uncomfortable (rhetorical) -)
Anyway, it fits the OP's requirements I'd guess.

First  |  Prev  | 
Pages: 1 2
Prev: Increment Value By 1 Each Time Spreadsheet is Opened
Next: Office Password Unlocker