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


.