Conditional formating
 

A2= $29
B2=$70

B4= should be green



If (B2)is greater than (A2) "highlight" (B4) green.

Conditional formating
 

Is this a question or an answer?

If a question................

Select B4 and FormatCFFormula is =B2A2

Format to green pattern and OK


Gord Dibben MS Excel MVP

On Sat, 22 Mar 2008 20:41:00 -0700, Jman wrote:

A2= $29
B2=$70

B4= should be green



If (B2)is greater than (A2) "highlight" (B4) green.

Conditional formating
 

"Gord Dibben" wrote:

Is this a question or an answer?

If a question................

Select B4 and FormatCFFormula is =B2A2

Format to green pattern and OK


Gord Dibben MS Excel MVP

On Sat, 22 Mar 2008 20:41:00 -0700, Jman wrote:

A2= $29
B2=$70

B4= should be green



If (B2)is greater than (A2) "highlight" (B4) green.

I should have clarified it .. it was a question.. Your answer is good if i dont find a better on for example..

Is is possible not to have to enter the "formula in B4" reason why, i
forgot to mention in B4 there is another formula and to enter the formula you
gave me it would conflict =B2A2

I was hoping there was a way to just have only the Highlihted color show up
in B4 not affecting any text already in B4.. IS there a way i can enter the
formula you gave me in Another cell. IF NOT.. your answer you already gave
me is helping a whole lot and i will use it, but i will have to make more
changes to my chart.
Sorry if i am not making sense.

Thanks for your reply.

Conditional formating
 

You need to read Gord's reply again.

It won't affect the text in the cell, because Gord was *not* telling you to
put the formula in the cell; he was telling you to use it in the "Formula
Is" option under Format/ Conditional Formatting.
--
David Biddulph

"Jman" wrote in message
...

I should have clarified it .. it was a question.. Your answer is good if i
dont find a better on for example..

Is is possible not to have to enter the "formula in B4" reason why, i
forgot to mention in B4 there is another formula and to enter the formula
you
gave me it would conflict =B2A2

I was hoping there was a way to just have only the Highlihted color show
up
in B4 not affecting any text already in B4.. IS there a way i can enter
the
formula you gave me in Another cell. IF NOT.. your answer you already
gave
me is helping a whole lot and i will use it, but i will have to make more
changes to my chart.
Sorry if i am not making sense.

Thanks for your reply.

"Gord Dibben" wrote:

Is this a question or an answer?

If a question................

Select B4 and FormatCFFormula is =B2A2

Format to green pattern and OK


Gord Dibben MS Excel MVP

On Sat, 22 Mar 2008 20:41:00 -0700, Jman
wrote:

A2= $29
B2=$70

B4= should be green



If (B2)is greater than (A2) "highlight" (B4) green.

Conditional formating
 

"David Biddulph" wrote:

You need to read Gord's reply again.

It won't affect the text in the cell, because Gord was *not* telling you to
put the formula in the cell; he was telling you to use it in the "Formula
Is" option under Format/ Conditional Formatting.
--
David Biddulph

"Jman" wrote in message
...

I should have clarified it .. it was a question.. Your answer is good if i
dont find a better on for example..

Is is possible not to have to enter the "formula in B4" reason why, i
forgot to mention in B4 there is another formula and to enter the formula
you
gave me it would conflict =B2A2

I was hoping there was a way to just have only the Highlihted color show
up
in B4 not affecting any text already in B4.. IS there a way i can enter
the
formula you gave me in Another cell. IF NOT.. your answer you already
gave
me is helping a whole lot and i will use it, but i will have to make more
changes to my chart.
Sorry if i am not making sense.

Thanks for your reply.

"Gord Dibben" wrote:

Is this a question or an answer?

If a question................

Select B4 and FormatCFFormula is =B2A2

Format to green pattern and OK


Gord Dibben MS Excel MVP

On Sat, 22 Mar 2008 20:41:00 -0700, Jman
wrote:

A2= $29
B2=$70

B4= should be green



If (B2)is greater than (A2) "highlight" (B4) green.


Ohh,, Thanks.. i missed that part...
Keep up the good work :)