Colum comparing

  • Thread starter Thread starter bryonrw
  • Start date Start date
B

bryonrw

Hello all,

Here is what I would like to do.
I have two columns D and E
They both have prices in them however I would like to highlight (o
hide) the row where the prices differ.


Thanks!
Bryo
 
So if one row of prices differ, the rows below that will probably be off
too...? You can use conditional formatting like

select column D. Go to Format>Conditional formatting> and choose "formula"
is =$D1<>$E1
choose format as red or higihlighted. Change the D1 and E1 to the first row
of your info.
 
A B C D E
1 2002384 Honda 82803 $486.46 $27.04
2 4875321 Walmart 53671 $200.00 $200.00
3 1431949 Ford G0103 $74.63 $25.70


I want to beable to example, have rows 1 and 3 highlighted (or hidden)
 
Hmmmm! Sounds like you need conditional formatting. Try selecting A1:E3, and
entering the formula $A1<>$E1in the "Formula is" box.
 
Back
Top