Can you use an Array in Conditional formatting.
I have a situation where I have a name in Column O with a list of names in Column M.
If the name in Column O appears in Column M, look at Column J. If the letter I, for incomplete, appears in Column J, in Column P, next to the name, turn the cell color Red. Otherwise, do nothing.
I don't know how to do multiple criteria using Conditional formatting. Can this be done with this problem?
If at all possible, I do not want to use VBA if possible. It is for someone else here at work.
Thanks for your help.
I included psuedo code on the spreadsheet (P6).