|
| Re: Conditional Formatting |
 |
Sun, 06 Jan 2008 15:43:04 -060 |
Fred Plett wrote:
> [This followup was posted to corel.QuattroProX3 and a copy was sent to the
cited author.]
>
> I am trying to conditional format in QPX3 (13.0.0.565) such that zero
> values have a white font color, and non-zero values have black, so the
> zeroes "disappear". I tried using both sheet properties
conditonal
> color, low value 0, high value 0, below normal color black, above normal
> color black, normal color white, and selection properties, numeric
> format, custom, YYYY, this cell=value zero, font color white, format
> 999999.99, this cell<>value zero, font color black, and neither
approach
> worked. Am I missing something?
>
No need to post twice. These groups are moderated and posts may be
delayed.
As to the problem, an expert will surely chime in.
|
| Post Reply
|
| Conditional Formatting |
 |
Sun, 6 Jan 2008 15:50:15 -0500 |
[This followup was posted to corel.QuattroProX3 and a copy was sent to the cited
author.]
I am trying to conditional format in QPX3 (13.0.0.565) such that zero
values have a white font color, and non-zero values have black, so the
zeroes "disappear". I tried using both sheet properties conditonal
color, low value 0, high value 0, below normal color black, above normal
color black, normal color white, and selection properties, numeric
format, custom, YYYY, this cell=value zero, font color white, format
999999.99, this cell<>value zero, font color black, and neither approach
worked. Am I missing something?
|
| Post Reply
|
|
|
|
|
|
|
|
|
|