highlight row differences

[Mark]

I'm trying to highlight the differnces in a row. I used the
Edit/goto/special/row differences and that works by highlighting the
differences. I want the highlights to stay though. so I can always see the
differences. Is this possible?
any help is very appreciated

 

[M Kan]

You could use conditional formatting: Formula Is:

=NOT(cell=target_ref)

 

[Mark]

v43 v43 v44 v44 v44 v44 v44
v82 v82 v84 v87 v89 v89 v89
v33 v33 v34 v34 v34 v34 v34
v55 v55 v57 v57 v57 v59 v59
v33 v33 v34 v34 v34 v34 v34
v67 v67 v69 v69 v69 v71 v71
v36 v36 v37 v37 v38 v40 v40

ok. this is what i'm working with. this is write from my spreadsheet. the
top left corner is a1 and the bottom left corner is G7. lets work with range
a1-a7. the first cell is 43 and so is the next one after that, but then it
changes to 44. thats what i want to highlight. your formula didn't work. any
new ideas? other examples would be b1 and b2 are 82 but then it changes to 84
then 87 then 89. this is what i want to track changes of.
Mark

 

[Mark]

Is there any one out there that can help with this? There has to be someway
of doing it.

 

[Peo Sjoblom]

Select B1:G1 with B1 as the active cell, do format>conditional formatting
and
use formula is, type in

=B1<>A1

click the format button and select pattern, select the colour you want and
click OK twice to exit out

to apply formatting for the rest use the format painter to "paint" B2:G7


--


Regards,


Peo Sjoblom