Conditional formating

J

Jman

A2= $29
B2=$70

B4= should be green



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

Gord Dibben

Is this a question or an answer?

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

Select B4 and Format>CF>Formula is =B2>A2

Format to green pattern and OK


Gord Dibben MS Excel MVP
 
J

Jman

Gord Dibben said:
Is this a question or an answer?

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

Select B4 and Format>CF>Formula is =B2>A2

Format to green pattern and OK


Gord Dibben MS Excel MVP


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

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 =B2>A2

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.
 
D

David Biddulph

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.
 
J

Jman

David Biddulph said:
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




Ohh,, Thanks.. i missed that part...
Click to expand...
Keep up the good work :)
 
Top