Conditional Formatting - HELP!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
For your conditional format choose formula and make the formulas

=$B$8="A"
and
=$B$8="O"

These are absolute referenced so you can copy the format down to cells
B9:B12 and they will reference B8.
 
Just to add,
you can also just select B9:B12 and then do your conditional formatting so
all cells get it at once.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Conditionals in MS Excel 2007 6
Colorindex and conditional formatting 2
Loop to hide sheet based on cell 1
Placing Icons 4
Counting Duplicates on two sheets 2
Conditional format if difference in cell values greater than 0.50% 1
Conditional Formatting with VBA 4
if true, if not nested if funcion 2

Back
Top