heinekeken
New Member
- Joined
- Sep 6, 2017
- Messages
- 1
Hi,
I would like to add another condition to my conditionnal formatting formula but i cant find the way to.
The conditionnal formating formula is :
[FONT="]=[/FONT][FONT="]SUMPRODUCT[/FONT][FONT="](N([/FONT][FONT="]ISNUMBER[/FONT][FONT="](FIND($A10;OFFSET(gout!$D$1:$AD$1;[/FONT][FONT="]MATCH[/FONT][FONT="](E$3;gout!$A:$A;0)-1;0)))))>0
[/FONT]the condition i would like to add in the formula is : cell value=[FONT="]regimes!H7
[/FONT]thanks
I would like to add another condition to my conditionnal formatting formula but i cant find the way to.
The conditionnal formating formula is :
[FONT="]=[/FONT][FONT="]SUMPRODUCT[/FONT][FONT="](N([/FONT][FONT="]ISNUMBER[/FONT][FONT="](FIND($A10;OFFSET(gout!$D$1:$AD$1;[/FONT][FONT="]MATCH[/FONT][FONT="](E$3;gout!$A:$A;0)-1;0)))))>0
[/FONT]the condition i would like to add in the formula is : cell value=[FONT="]regimes!H7
[/FONT]thanks