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 :)
|