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.