Background color according to a specific cell value
 

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.

Background color according to a specific cell value
 

hi
we don't either.
what is in B9?
what conditon(s) would change the color?

regards
FSt1
"One-Leg" wrote:

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.

Background color according to a specific cell value
 

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.


"FSt1" wrote:

hi
we don't either.
what is in B9?
what conditon(s) would change the color?

regards
FSt1
"One-Leg" wrote:

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.

Background color according to a specific cell value
 

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
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"One-Leg" wrote:

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.

Background color according to a specific cell value
 

Thanks!!! It worked like a charm...

"M Kan" wrote:

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
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"One-Leg" wrote:

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.

Background color according to a specific cell value
 

hi
better.
select B1
on the menu bar...
formatconditional format
formula is.......=B$9="Closed"..........format gray
ok.
copy B1. paste in desired cells.
done
Regards
FSt1

"One-Leg" wrote:

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.


"FSt1" wrote:

hi
we don't either.
what is in B9?
what conditon(s) would change the color?

regards
FSt1
"One-Leg" wrote:

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.

Background color according to a specific cell value
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"One-Leg" wrote in message
...
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.