Conditional formatting

[#1]

I want to use a route map for a transport system and show the value of say ticket sales at each stop.

I planned on using a text box for each stop (maybe just add a picture of a dot to the text box?)

I wanted the text box/ picture of the dot to be formatted in different colors depending on the value.

Rather than enter absolute values to the text box i wanted them to just change color as they do in Excel ie the highest value say dark red and the lowest a very pale red

Any ideas?

[its_anandrjs]

Hi,

Can you provide any sample of the excel file it will better but i thing you can use .selection count or the images.

HTH

Thanks & Regards

[Peter_Cammaert]

Text in text boxes has a color button in Properties->Font. If you open the corresponding dialog, you will find a Base Color area on the right. Select "Calculated" instead of fixed, and enter an expression that results in a variable RGB value depending on the value of the data point. Use rgb(), colormix1() and colormix2() functions and your original datapoint expression to present a dynamic color for each route point.

There is a great tool for such things if you're not familiar with the colormix functions. In the above "Calculated" expression field, open the Edit Expression dialog (press the gray "..." button) and from the File menu, select Colormix Wizard...

Good luck,

Peter

[Anonymous]

Text box  properties goto font tab

select color - base color (conditional) - expression.

if(Year>2009,Green(),Red())

Will give the desired output

Please see attached

Hope this helps