Groups > WordPerfect Office > QuattroPro X3 > Conditional Formatting




Re: Conditional Formatting

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
about | contact