How 2 Format a column selectively

B

Bill Meacham

How can I format a column selectively? The column in question is Total
Slack. If its value is less than zero I would like it to display in a
different color. Is there a way to do this?
 
J

JackD

You can not format a column selectively.
You can format a row selectively based on the value in a column (create a
filter , check the "highlight" box for that filter, then go to format menu
and set the text style for "highlighted" tasks the way you want.
 
G

Gérard Ducouret

Hello Bill,

You can't really a column selectively, but you can display some specific
graphical indicators such as red, yellow or
green lights, but not directly in the Total Slack field :
Insert un Number(x) column, right click its label
Customize field / Formula
[Total Slack]/[Minutes per day] (or something like that : I don't have the
english version in front of me.)
Click the Graphical indicators button
Less than.... 0 ... red light

Hope this helps,

Gérard Ducouret
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top