Does anyone know the expression for my example:
In cell B8, I have a drop-down list to select either "A" or "O" and applied
a conditional format if cell value is "A" apply green and if cell value is
"O" apply red.

Here's where my problem is:
I would like to apply a conditional format to cells B9-B12 based on the
value of B8... if B8 equals "A" then apply green or if B8 equals "O" then
apply red. Can this be done?

Many thanks!!
LisaD