Edit the format of one field based on the value of another field in that record

[Ruby M]

Hi,

I have created a layout for keeping records of all the projects my company is working on.

I have created a field called 'Status' which is a drop down menu containing 2 values: Live and Complete.

There is also a field in the layout that is for entering the name of each project. I want to use conditional formatting to change this field to the 'StrikeThru' style when the 'Status' value is changed to Complete.

I have tried creating an If formula within Conditional formatting but its not working.

Any help would be much appreciated,

Ruby

[cpe1704tks]

Ruby M

I used this calculation here in the conditional formating on the project field:

strike through::status = "Complete"

then i selected the strike through option

cpe1704tks

strike_through.zip

[Ruby M]

Fantastic, Thanks a lot!