finding difference between two cells

[vletm]

maniniinfotech
You seems only know terms: ask, need, want ...
Do You know that sentences which ends with ? are questions.
Normally questions means that someone is waiting answer. (This sentence is not a question.)
You have changes Your needs as many times as You have written ...
After I offer borders --- You didn't want borders --- after I offered as You wanted with those 'boxes' --- You changed You wants again ...
Sometimes, You wanted to use Conditional Formatting ... do You remember what happened?
Who know what would be You next need/want?
Do You know Yourself?
You have had many variations ... maybe there are still few more which You haven't asked/wanted ...

 

[maniniinfotech]

maniniinfotech
You seems only know terms: ask, need, want ...
Do You know that sentences which ends with ? are questions.
Normally questions means that someone is waiting answer. (This sentence is not a question.)
You have changes Your needs as many times as You have written ...
After I offer borders --- You didn't want borders --- after I offered as You wanted with those 'boxes' --- You changed You wants again ...
Sometimes, You wanted to use Conditional Formatting ... do You remember what happened?
Who know what would be You next need/want?
Do You know Yourself?
You have had many variations ... maybe there are still few more which You haven't asked/wanted ...

Am really sorry vletm kindly excuse me at this time because today I am seeing this mail please consider my apalogy

 

[maniniinfotech]

It's a request from my side to consider my apalogy

 

[maniniinfotech]

Please give me a chance for this time so that it will not be repeated again

 

[vletm]

maniniinfotech
You should already know, what You should do ...
I've given my samples ... some parts are missing, because no answers from You.

 

[maniniinfotech]

as i am not able to understand the coding and still trying to learn from basic i might require some time so please teach me

 

[maniniinfotech]

in the given attachment and sheet 5 i need to match both data as you were provided me earlier and dependents should be traced based on color
if try match the both sets then color been adding inside cell it should take the color for borders or shapes
i have uploaded the data which you have provided me and what i have done that is colour code and result
i don't know vba kindly teach me and help me please

 

[vletm]

maniniinfotech
You still continue same ...
... and You skip all others writings ...
Sheet3 with borders
Sheet4 with boxes

 

[maniniinfotech]

ok vletm kindly let me know what should i answer please am confused

 

[vletm]

maniniinfotech
As I've tried to write 'few' times...
Sentences which the last mark is ? - are questions.
Those sentences are waiting for answers.
Other sentences should also read and after that You do not need to ask, want ... something which I have already written.

 

[maniniinfotech]

I cannot understand the colour coding required from either the workbook attached to msg#61 (the conditional formatting is all over the place) or from the picture. Not a hope.

The attached is vletm's file with additional sheets:
Sheet3 is vletm's original border-colouring solution
Sheet4 uses an adapted version of vletm's code but places shapes on each cell instead, keeping vletm's colour coding. You can compare the results on Sheet3 and Sheet4 easily.
Sheet5 is where I've taken out the extra rows since they're not needed for colouring anymore.

This means you'll be able to keep the conditional formatting for comparing two tables, and you no longer need the conditional formatting for the 4 cells around each number.

There's a little flexibility to adjust how the shapes are placed on the sheet:
1. The thickness of each line can be adjusted; in Module 1, macro blah, there's a line:
Thickness = Application.Min(.Width, .Height) * 0.2
The 0.2 here means 20% of the height or width of the cell, whichever is the smaller.
When the value is .05 (=5%) you get:
View attachment 62478

When it's 0.3 (=30%) you get:
View attachment 62479

2. You can move the shapes away from the edges of the cell to introduce a bit of (currently white) space between cells.
There's a line just below the one mentioned in (1.) above:
ofset = 0
When this has a value of zero, the shape goes right to the edge of the cell as in the pictures above.
When the value is 1 you get:
View attachment 62480

Each time the button is clicked, some 300 shapes get added to the sheet; if they're not removed before clicking the button again the numbers of shapes on a sheet can quickly get into the thousands, so there's another button to remove them.

HI P45CAL this will be the last thing i will be asking you kindly check the attachment
i did conditional formatting but both tables are not matching please provide me the solution