ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional formatting/ comparing worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/125605-conditional-formatting-comparing-worksheets.html)

Excel Help!

Conditional formatting/ comparing worksheets
 
I need to compare data from 2 worksheets. There are three rows of data I
need to compare in each worksheet:
WS - A
A,B,C,D,E,F,

WS - B
A,B,C,D,E,F

I need to compare WS-A, row B,D,F with WS-B row B,D,F and store the
different in a third worksheet and/or apply conditional formatting to both
worksheets. I would appreciate any help. Thanks.....


All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com