Q Conditional Formatting
 

Greetings:

Is it possible to apply conditional formatting to a cell which is NOT the
cell being modified?

For example, if I enter a 5 in cell A1, can Excel change the background
color of cell B1 to yellow?

(I know this can be done with VBA, but I'm wondering if there is a way to do
it with conditional formatting.)

Feedback is appreciated. Thanks.

Q Conditional Formatting
 

hi Marty,

select b1, format | conditional Format, change to "the formula is" and type
a1=5 format as you need

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marty" escreveu:

Greetings:

Is it possible to apply conditional formatting to a cell which is NOT the
cell being modified?

For example, if I enter a 5 in cell A1, can Excel change the background
color of cell B1 to yellow?

(I know this can be done with VBA, but I'm wondering if there is a way to do
it with conditional formatting.)

Feedback is appreciated. Thanks.

Q Conditional Formatting
 

Marcelo: Thanks for the response, but it didn't work.

When I re-opened the conditional formatting box, it now looks like this:

="A1=5"

Excel added the equal sign on the left and the quotes.

What did I do wrong?

"Marcelo" wrote:

hi Marty,

select b1, format | conditional Format, change to "the formula is" and type
a1=5 format as you need

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marty" escreveu:

Greetings:

Is it possible to apply conditional formatting to a cell which is NOT the
cell being modified?

For example, if I enter a 5 in cell A1, can Excel change the background
color of cell B1 to yellow?

(I know this can be done with VBA, but I'm wondering if there is a way to do
it with conditional formatting.)

Feedback is appreciated. Thanks.

Q Conditional Formatting
 

The formula should be:

=A1=5


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Marty" wrote in message
...
Marcelo: Thanks for the response, but it didn't work.

When I re-opened the conditional formatting box, it now looks like this:

="A1=5"

Excel added the equal sign on the left and the quotes.

What did I do wrong?

"Marcelo" wrote:

hi Marty,

select b1, format | conditional Format, change to "the formula is" and
type
a1=5 format as you need

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marty" escreveu:

Greetings:

Is it possible to apply conditional formatting to a cell which is NOT
the
cell being modified?

For example, if I enter a 5 in cell A1, can Excel change the background
color of cell B1 to yellow?

(I know this can be done with VBA, but I'm wondering if there is a way
to do
it with conditional formatting.)

Feedback is appreciated. Thanks.

Q Conditional Formatting
 

That worked. Thanks.

"RagDyeR" wrote:

The formula should be:

=A1=5


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Marty" wrote in message
...
Marcelo: Thanks for the response, but it didn't work.

When I re-opened the conditional formatting box, it now looks like this:

="A1=5"

Excel added the equal sign on the left and the quotes.

What did I do wrong?

"Marcelo" wrote:

hi Marty,

select b1, format | conditional Format, change to "the formula is" and
type
a1=5 format as you need

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marty" escreveu:

Greetings:

Is it possible to apply conditional formatting to a cell which is NOT
the
cell being modified?

For example, if I enter a 5 in cell A1, can Excel change the background
color of cell B1 to yellow?

(I know this can be done with VBA, but I'm wondering if there is a way
to do
it with conditional formatting.)

Feedback is appreciated. Thanks.

Q Conditional Formatting
 

=A1=5
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marty" escreveu:

Greetings:

Is it possible to apply conditional formatting to a cell which is NOT the
cell being modified?

For example, if I enter a 5 in cell A1, can Excel change the background
color of cell B1 to yellow?

(I know this can be done with VBA, but I'm wondering if there is a way to do
it with conditional formatting.)

Feedback is appreciated. Thanks.

Q Conditional Formatting
 

Thanks for the feed-back.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Marty" wrote in message
...
That worked. Thanks.

"RagDyeR" wrote:

The formula should be:

=A1=5


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Marty" wrote in message
...
Marcelo: Thanks for the response, but it didn't work.

When I re-opened the conditional formatting box, it now looks like this:

="A1=5"

Excel added the equal sign on the left and the quotes.

What did I do wrong?

"Marcelo" wrote:

hi Marty,

select b1, format | conditional Format, change to "the formula is" and
type
a1=5 format as you need

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marty" escreveu:

Greetings:

Is it possible to apply conditional formatting to a cell which is NOT
the
cell being modified?

For example, if I enter a 5 in cell A1, can Excel change the
background
color of cell B1 to yellow?

(I know this can be done with VBA, but I'm wondering if there is a way
to do
it with conditional formatting.)

Feedback is appreciated. Thanks.