Conditinal formatting

[rizmomin]

Hello:

Please refer to attached file.

I need to apply conditional formatting as below.

I need to highlight cell A2 to red if A2 = file name in N2:N34 and if the corresponding cell in column O is YES.
For Example:
I find a match for A2 in cell N3 and O3 is YES, hence i need A2 to be Red.


Let me know if you have any questions.
Thanks.


Riz

[Richard Buttrey]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.