Red line certain records

[skystar70]

Hi. I am on version 9. Can I write a formula to put a red line through records that meet certain criteria? I only want the line to be red. I want the text to be black. I know I can make both the text and line red or both black by doing a font formula for strikeout. And I know I can put a red line through all records by inserting a line, but I cannot put a formula on an inserted line.

Any ideas or formulas I can write for this?

Thanks!
Skystar

 

[HowardHammerman]

I would create another formula with IF THEN ELSE logic that printed the line charcter when you wanted it to and nothing ("") when not. You will have to find the ASCII character for the line and then repeat it X number of times to fit the space of your field.
Save the fomula and then color it red. Then move it so that it overlays the field you want to format.

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[lbass]

You could use one side of a text box as a line. You can make the line conditional, and you can also color the border red.

-LB

 

[skystar70]

Thank you both very much. I'm going to go with the one side of the text box. Much easier for me.

Skystar