Conditional formatting disrupted with drop down menu?

[aherzog]

I have a worksheet which has 12 columns. Each row is a record of service calls which my technicians go on. 3 of the 12 columns also include drop down menus (Columns A, D & E). The first column is a "status" drop down, and the options are either an X mark or a check mark. If there is a check mark, then that whole row turns yellow to mark that it has been completed. The only problem is the other two columns which also contain drop down lists (one if for client, other is for technician name) - if either of these are selected, then that particular cell remains uncolored while the rest of the row is colored in yellow. I had made a worksheet similar to this before where I got the entire row to color, even with the drop down menu. Problem is that I can't remember how I got this to work! Any suggestions? I know it is something simple, but at the moment it slips my mind. Thanks.

 

[aherzog]

I figured it out! I just moved it from the bottom of the "manage conditional formatting" list to the top under the "this worksheet" category.