Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight row differences
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight row differences
You could use conditional formatting: Formula Is:
=NOT(cell=target_ref) -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Mark" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight row differences
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 "M Kan" wrote: You could use conditional formatting: Formula Is: =NOT(cell=target_ref) -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Mark" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight row differences
Is there any one out there that can help with this? There has to be someway
of doing it. "Mark" wrote: 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 "M Kan" wrote: You could use conditional formatting: Formula Is: =NOT(cell=target_ref) -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Mark" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight row differences
Select B1:G1 with B1 as the active cell, do formatconditional 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 "Mark" wrote in message ... Is there any one out there that can help with this? There has to be someway of doing it. "Mark" wrote: 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 "M Kan" wrote: You could use conditional formatting: Formula Is: =NOT(cell=target_ref) -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Mark" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I highlight data differences in workbook | Excel Worksheet Functions | |||
Calculate differences between age | Excel Discussion (Misc queries) | |||
How do I compare 2 sets of data and highlight differences? | Excel Worksheet Functions | |||
how to merge 2 worksheets and highlight differences | Excel Worksheet Functions | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) |