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