Conditional Formatting - formula issue

[Bjordion]

Hello,

I have written the following two formulas as separate conditions within CD. They each produce the desired CD result:

=COUNTIFS('Sheet2'!$F:$F,$A45,'Sheet2'!$K:$K,$H45)
=COUNTIFS($J45,"DELETED")

However, when I combine them as the following, the CD fails:

=COUNTIFS('Sheet2'!$F:$F,$A45,'Sheet2'!$K:$K,$H45,$J45,"DELETED")

How can I combine both sets of conditions to produce the desired CD?

Thank you in advance!

Bjordion

[Pete_UK]

Try it like this:

=OR(COUNTIFS('Sheet2'!$F:$F,$A45,'Sheet2'!$K:$K,$H45),$J45="DELETED")

or like this:

=AND(COUNTIFS('Sheet2'!$F:$F,$A45,'Sheet2'!$K:$K,$H45),$J45="DELETED")

depending on how you want them connected.

Hope this helps.

Pete

[Bjordion]

Always the simplest solution...

Many thanks Pete.