Help greatly needed - Conditional formatting

A

AlexQ

New Member
Joined
Sep 18, 2014
Messages
18
Hello, I basically have 50 worksheets, each work sheet has 2 tables in it. An old one and a new one they all have the same titles etc, I need to compare the data. For instance A2-A43 is the old then A46-A87 is the new. Now what I want to do is if a change is present between the two of them highlight it red...
Example
A2 10
A3 5
A4 5

A46 10
A47 5
A48 10

How would I get it so that both A4 and A48 become highlighted, and also if I was to change the cell value to be the same would it then go away? As this is what I'm looking for. Regards , please reply today... I am struggling. Alex.
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Sort by date Sort by votes
Welcome to MrExcel.

For A2:A4 the condition would be Cell Value not equal to A46. For A46:A48 the condition would be Cell Value not equal to A5.
 
Upvote 0
Hi Andrew,

Thank you for a quick reply... This was just an example and I am totally new to excel my actually worksheets are a lot more in depth. Is there any way I could just create a custom conditional formula to sort this for me?

Alex
 
Upvote 0
It can be multiple, I just need to know what to write in them lol, this is all new to me. I've watched videos but not had much luck :(
 
Upvote 0
Just for the record, in the sheet I am working on now there are no changes, but I just want to be able to check to make sure the formatting is working... For example if I changed A46 to a 10 from say a 20 would A2 and/or A46 become highlighted? Just could do with the content to post in the formulas to test it.
 
Upvote 0
Let's try this instead

Select A2

Conditional Formatting
New Rule
Use a formula to determine...

=(OFFSET(A1,1,0)<>OFFSET(A1,42,0))

format as required
Use Format painter (paintbrush icon) to copy to other cells including A46 onwards
 
Last edited:
Upvote 0
Okay so for the record in this worksheet it's L2-L43 then the new worksheet starts L46-L87 so I select L2 and enter =(OFFSET(L2,2,0)<>OFFSET(A2,42,0)) ?

And then what do I do in the applies to bit?

Alex
 
Upvote 0
oozwib.png
So am I right?
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Solved
Split first word only if it is part of a range.
2
Replies
15
Views
355
mumps
mumps
S
  • Question
Conditional Formatting with Self-Reference to ISBLANK
Replies
6
Views
192
Fluff
Fluff
J
  • Question
Conditional Formating Help
Replies
4
Views
132
Alex Blakenburg
A
F
  • Solved
Conditional Formatting
Replies
8
Views
155
Joe4
Joe4
H
  • Question
Conditional Formatting
Replies
1
Views
154
SanjayGMusafir
SanjayGMusafir

Forum statistics

Threads
1,214,661
Messages
6,120,790
Members
448,994
Latest member
rohitsomani

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top