Here is a graphical example. Any cell in the data column that matches any one of the unique reference cells I want to highlight that row. Assume the Reference column needs to go on a separate tab?
Good morning,
Appreciate the guidance you provided on this thread. for some reason, I inputted the instructions and for some reason when I select "No-show" from the drop down on Column " F" the red goes down a row. So it is not highlighting the row that the drop down in in. Please advise and thank you Yury.
Most probably references in formula and in Apply To range are not in sync. For example
we use in formula reference with first row and apply to the range which starts from the second row. If to change on row 2 in formula, it works
I'm trying to do a similar type of formatting where a row is highlighted when the end cell says completed. It works fine for one row however when I add more to the range the entire range is highlighted despite only the first row containing "completed" in the appropriate column. 
Hello!
I am struggling with getting multiple CF rules to run in sequence. My goal is to have the row color change as new information is entered into specific cells in specific columns. However, I don't know how to write the formula.
CF iterates ranges cell by cell, apply to the cell formatting for the first rule which returns TRU and ignores other rules:
If we change rules order that will be
Depends on your goals use according order of rules.