CODEWITHSUNDEEP
excel
dadarara
dadarara

Reputation: 1

Excel, complex conditional formatting

looking to have this result

enter image description here

have this data

enter image description here

need to configure the conditional formatting for this.

little confused as to how to write the formula tried :

COUNTIF(Sheet2!$C$3:$C$5,$J6) +COUNTIF(Sheet2!$D$3:$D$5,">="&K$1) +COUNTIF(Sheet2!$E$3:$E$5,"<="&K$1)

Upvotes: 0

Views: 48

Answers (1)

blub
blub

Reputation: 1014

Not sure if i understood your problem. Does this help?

The formula obviously needs to be in the conditional formatting formula, not some cell, I just put it in the screenshot to show the corresponding ranges of my example more clearly.

In this example the "applies to"-area begins with B2 enter image description here

Upvotes: 1

Related Questions