View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.