Add one condition to Conditional formatting

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=&quot]=[/FONT][FONT=&quot]SUMPRODUCT[/FONT][FONT=&quot](N([/FONT][FONT=&quot]ISNUMBER[/FONT][FONT=&quot](FIND($A10;OFFSET(gout!$D$1:$AD$1;[/FONT][FONT=&quot]MATCH[/FONT][FONT=&quot](E$3;gout!$A:$A;0)-1;0)))))>0

[/FONT]
the condition i would like to add in the formula is : cell value=[FONT=&quot]regimes!H7

[/FONT]
thanks
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

mart37

Active Member
Joined
Aug 4, 2017
Messages
342
=SUMPRODUCT(($A10=regimes!$H$7)*(N(ISNUMBER(FIND($A10;OFFSET(gout!$D$1:$AD$1;MATCH(E$3;gout!$A:$A;0)-1;0))))))>0
 

Watch MrExcel Video

Forum statistics

Threads
1,099,113
Messages
5,466,752
Members
406,496
Latest member
Arlind Elezi

This Week's Hot Topics

Top