Column Comparision-Progressive scan and format cell

@nilem, Thanks for the feedback.

When I run the macro, nothing happens.

In my sample data - B3, the equal or +- 2 days are 16 Oct in Column C, 13 Oct in Column I


Here is the sample file - http://www.mediafire.com/?926li1v6z633j35

You are right, that worked, but

1) I've large data range having date format only, and changing them manually would be a nightmare, how do i reformat the cell as Date only, and no time.

2) This macro would compare Column B with each subsequent column till Column V. What if i want to carry out same procedure, once above is done starting with Column C, and comparing each cell in subsequent column D to V, then, starting from Column D and comparing each cell in it with Column E till column V and so on till Last column comparison U with V only.

Thanks

I could surely do Find and replace ' *' (space and asterix without quote) to remove the time element, that would be faster.


SPLENDID, code at # 6 does the job. Nicely, Thanks, pal.

Now, can u please help for part 2 only. The first part of the macro compares Each cell in Column B with Column C, D, E, and so on till Column V

How nice, if code later compares (with same criteria) each cell from Column C with Column D, E, F and so on till V, then
compares each cell from Column D with Column E, F, G, H and so on till V, then
compares each cell from Column E with Column F, G, H, I and so on till V and lastly
compares column U with Last column V only, and does the same thing

P.S. : 1) Instead of Font color change, can we fill entire cell with color, in order to get attention easily
2) Even if there is overwrite situation for column comparision, that would not be an issue.

Thanks

it would have already been formatted earlier, and again if it gets formatted no issue.

At the end, it is not important which cell in a given column is match against cells in other column.

I just want to see the match dates per given criteria in each column at the end, regardless of its base.

So, Macro in post # 6 is more good for me.

So, alternatively, I was thinking to duplicate it by creating series of variables, and then start comparing Column C, then Column D and so on!!! (crude way to write code)

take a look at post #8 and change this part of the code

Please Login or Register  to view this content.

for this

Please Login or Register  to view this content.

edited
doubt it, but if you exactly follow your description,

Please Login or Register  to view this content.

Done, Thank you very much. Macro in # 12, does the job as desired.

How nice of you.

Only one question, all being same, instead of starting with Column B, which line of the code, should be changed to what, if I want this analysis to be carried on starting from Column E.

In your last modified code given in # 12

Please Login or Register  to view this content.

Thank you very much nilem for your prompt replies.

While I am keeping active cell as B2, and run this macro (ertert444), it formats certain blank cells too, and many other cells that meet the criteria remains un-formatted.

Here is the file for your look - http://www.mediafire.com/?exnn8d07vaf1jp4

P.s: pwd removed from file, apology. Sample data in Sheet9. In sheet9, macro named- ertert44_REV(), works, however, IT changes the color of all cells. I have different color in Header Row1 and 2 for specific reason. Is there any way to untouch Row 1, and 2, and Keep Data+format unchanged in Column A, on left hand side.

Thanks, this works. On this very same subject, can i ask for some more alternates, after few days or whenever you are comfortable.?

I think, the alternate, is not very tricky, as the main solution you have very well managed to find.

Thank you, very much for your precise, prompt solution, SIR.

The alternate scenario would be -

Perform same process but when we start from Column E, it should compare in alternate column till Column V

i.e. Start with Column E, skip column F, and compare each cell in Column G with same criteria, and then Column I, (skip Column H) then Column K (skip column J) and so on and color cell in given color,

then start from Column G (skip Column F) and compare in alternate subsequent columns.....

Once this is done,
It should start from Column F, skip Column G, and compare with H, skip Column I, and compare with K and so on. and give different color.

So now, the comparison is in alternate columns from left to right

Good if this could be done, else, I will continue with solution given in #23 above.

File and data would be same.