apply 2 condition formatting on the same row

Hi, I need to apply 2 condition formatting on the same row by using drop down list.
The first condition formatting is to highlight the cell in difference colour
For example the whole row will turn in green if cell $K12="Yes"
And then I want to apply another Condition formatting on the same row if cell $N12= "complete" by grey out the text or disable the roll.
Is there anyway to do this?
I'm using excel 2011 on Mac.

Thank You.

Hi, Thanks for helping but I cannot download the file

Originally Posted by ramananhrm

Are you looking for this result?

Hi, I'm able to download the file now. The result that that need is that the row still highlight as green colour but the text inside is grey out or disable to change.
Is there any possible way to do that?

Originally Posted by FDibbins

Hi and welcome to the forum

Assuming you want the "grey" to take precedence over "green", try this (I am unfamiliar with mac, so I hope the commands are the same/in the same place)

1. highlight the range you want to apply the conditional formatting to (for instance A2:J20)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter $K12="Yes format fill GREEN

Repeat 3 and 4 with $N12= "complete" format fill GREY
This rule should now be the 1st/top rule, and beside it, should be a box to check "stop if true" - check that box

Thank you, FDibbins.
What I need is the row still remain its colour but only the text will turn to grey if N12=Complete, or the row will be disable if N12=Complete.
Is there any possible way to do that?