Hello all. I have conditionally formatted cell O11 to change color based on one of the 7 selections in a drop down menu in the same cell. My question is, how can I do this where all the entry cells in that row change color according to that drop down selection?

In other words, if O11 is formatted to turn green because "submitted" was selected from the drop down, how do I format it to where cells B11, C11, D11, E11, F11, G11, H11, I11, J11, K11, L11, M11, N11, etc... change to green as well?

Please keep in mind that VBA is disabled here at work.

Then, once I format it this way, how do I apply that for all rows based on the selection of the drop down text in column O?