Background color according to a specific cell value

  • Thread starter Thread starter One-Leg
  • Start date Start date
O

One-Leg

Hello,

I have a document in which I want cells B1, B2, B3, B4, B5, B6, B7, B8 and
B10 to see their backgroubnd color change depending of the info fond in cell
B9...

I knwo I must use "Conditional Formating" but I just don't know exactly what
I need to enter as information.

Thanks in advance to all for any assistance.
 
There will be 2 values in B9 (in a drop down list)...

OPEN
CLOSED

When OPEN is selected, I want the cells to remain white. When CLOSED is
selected, I want all cells mentionned bellow to turn grey.
 
In the Conditional Formatting wizard, select Formula Is from the drop down
box and use the formula =$B$9="criteria" and then you can use hte format
painter to apply this to all cells. As posted by FSt1, you didn't specify
what was in B9
 
Thanks!!! It worked like a charm...

M Kan said:
In the Conditional Formatting wizard, select Formula Is from the drop down
box and use the formula =$B$9="criteria" and then you can use hte format
painter to apply this to all cells. As posted by FSt1, you didn't specify
what was in B9
Click to expand...
 
hi
better.
select B1
on the menu bar...
format>conditional format
formula is.......=B$9="Closed"..........format gray
ok.
copy B1. paste in desired cells.
done
Regards
FSt1
 
Let's say you want B1 to be red when B9 has value 10 or more
Select B1; use Format | Conditional Formatting
In dialog: Formula is =B9>=10; now pick the format
Click Ok
Your done
best wishes
 
Back
Top