InfoPath Dev

I want to change the formatting of a cell based on the conditions on the table cells that follows.

It goes like this

STATUS CELL

column1       column2

Cell1           Cell2"YES/NO"

Cell3           Cell4"YES/NO"

If a name is entered in column 1 then it checks whether column 3 is YES then changes the status of the cell to green else it stays red.

So I used the following code:

cell1 is blank and cell2 is blank or
cell1 is not blank and cell2 is equal to YES and
cell3 is not blank and cell4 is equal to YES

then status cell is green.

I cant seem to get the above to work and if someone could guide me on where I am wrong I would be really grateful.

Regards,

Monk

Hi Monk_mst and welcome,

I need to look at your form. Can you reply and attach it in the options tab?

Thanks!

 Hi Patrick,

 Thanks for your support in advance.

 Regards,

 Monk

 The logic will be a lot cleaner if you use a repeating structure and keep track of the Pass/Fail values for each row. Please have a look at the attached form. I populated the table using the Default Values dialog accessible from the Data tab in InfoPath 2010.

Thanks Jimmy,

I think I understand the logic of what you have designed and it does make a lot of sense. This is my first attempt at a form through trial/error, please bear my ignorance if you can. Also, looking at the rules you have applied I have a lot to learn.

Thanks again,

Monk