Text format in field A conditional on field B

[Philip Jenks]

I want to make the text in a field red if another field has a '1' in it. The second field would indicate that a product is out of stock, and when that is the case, I'd like the name of the product in the first field to be displayed in red (or possibly 'strike through' so that I can immediately see that the product is redundant.

Anyone know how I can do this. Apologies if it's a really basic question, but I'm pretty much a beginner.

Thanks.

[-Queue-]

Create a calculation field of Case( field2 = 1, name ). Stack this field on top of your normal name field, format the text to be red, and format the background to be transparent.

[Philip Jenks]

Queue

Thanks for your help. Worked a treat! Very grateful.

Philip