Row color change based on drop down selection

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?

Hmm, that should have worked. Did it do anything?

Pauley

it did nothing.

It might help if you upload a sample spreadsheet with your issue.