combine 2 conditional formating rules

[abaines]

Hi everyone, I have two conditional formatting rules that work independently, but I am looking to combine them into 1 rule, making (2) subject to (1) when (1) is true

(1) =$B3:$B6="y"
(2) =AND(COUNTIF(K$3:K$6,MIN(K$3:K$6))=1,K3=MIN(K$3:K$6))

Thanks for your help

[Motu040602]

Try this in the formula for the condtional cells. I am not sure it is perfect. I can't see exactly what you are trying to do with it from the above description. Good luck!

=And($B3:$B6="y",AND(COUNTIF(K$3:K$6,MIN(K$3:K$6))=1,K3=MIN(K$3:K$6)))

[abaines]

Thanks for the reply but it doesn't do what I'd like it to do.

what I'm trying to do is in the cells where:
=$B3:$B6="y"
is true,
apply:
AND(COUNTIF(K$3:K$6,MIN(K$3:K$6))=1,K3=MIN(K$3:K$6))) (finds the minimum, if the minimum is unique)

I'd be more than happy to post the sheet if that would help.

[Tony Valko]

I think we'll need to see a small sample file. Make sure you tell us which cell(s) should be formatted.

[abaines]

I've attached a sample workbook with a better description of what I am trying to do.
Hope this helps

[Tony Valko]

Try this...

=AND(B3="Y",COUNTIFS(B$3:B$10,"Y",K$3:K$10,MIN(K$3:K$10))=1,K3=MIN(K$3:K$10))