Conditional formatting of the adjacent cells

[Dunyazada]

Hello everyone!
I have a form based on a table with two fields. I need to format cells in the field 1 that contain the word "World" and the adjacent cells in the field 2. I did format the cells from the first field, but have no idea how to format those in the second field. Does anybody know how to do it?

 

[Isskint]

Just reference the field name. EG in control for Field1 to set a format conditional on field2 use;

([Field2]=5)

 

[Dunyazada]

I am sorry, I don't think I understand. If I use the Conditional Formatting Rules Manager, what rule should I put in there?

 

[Isskint]

When you open the Conditional format rule manager, select Expression Is instead of Field Value Is. Then type this in the condition box; ([FieldX]='World') - where fieldX is the name of your field1. Set the formatting you want applied and click OK. See the attached image

 

[Dunyazada]

Oh my god, you totally saved me! Thanks a lot