Posts by raganna

Hi Dave,
Really appreciate your quick response with this fantastic solution. Thanks a lot for your solution.

But just wanted to inform you that, just for understanding purpose I had highlighted certain values in Red colour. In actual, there is no unique colour. It will be in the same colour as like other values.

If possible, can you "PLEASE" give me in a Formula manner instead of Code format ? It's a request and I am very desperate to see in a formula manner.

Thanks a lot for your time and for the solution that you have provided!!!!!!

Hi all,
Hope all is good.

Can anyone please help me with any of the solution for my requirement as explained below ?

Please see attached, the excel file for better understanding of my question.

In the column 'B' (Sequence), there are certain values and just for my explanation, I have considered just 25 rows.

I have highlighted few of the values in red colour in column 'B'.
Reason being, I need only those values which are to the left of highlighted value and including the highlighted one as well as shown in the column 'C' (Output).
I don't need any of the values which are to the right of highlighted value. It has to be deleted from Column 'C'.

Is there any option (Formula or anything) where I can reduce my time ?
Can anyone please suggest me on how I can do it in an efficient manner instead of entering manually for each and every row?

[SIZE=14px]In short:[/SIZE]
I need only the values which are to the left of highlighted value in red colour and including the red colour one. The one that are to the right of highlighted value must not be there in the output.

Thank you all for your efforts and many Thanks in advance for your suggestions.

Re: Highlight Duplicate values by not highlighting any one of its parent value

Hi all,
Sorry for cross posting this thread.

Please see the below link for the solution of this thread.

https://www.excelforum.com/exc…-of-the-parent-value.html

Thank you all for sorry to waste your time.

Hi all,
Hope everything is fine.

Requesting anyone to help me in achieving my requirement.

Just for my explanation I have attached a sample of my excel file. Kindly look into it.

I have shown the sample in 2 different sheet. One is Using highlight duplicate values from conditional formatting and the other sheet I done manually just for better understanding.

My requirement is that,

In Column 'B', I have certain values which are duplicated and some aren't. Is there any method or any command wherein it should highlight only the children values. From the repeated values, anything can be children and anything can be parent irrespective of the other columns.

Example:
In column B, mfngb1 is used 4 times. When used conditional formatting and highlight Duplicate values, it highlights all the 4 cells. But I need only 3 to be highlighted leaving behind one cell unhighlighted (Any 1 out of those 4 can be unhighlighted).
Similarly, mfngb2 is used 5 times. When used conditional formatting and highlight Duplicate values, it highlights all the 5 cells. But I need only 4 to be highlighted leaving behind one cell unhighlighted (Any 1 out of those 5 can be unhighlighted).

In general, the unhighlighted values must be unique values.

If the value is not repeated, it shouldn't highlight that value.

Thanks in advance for your time.

Hi all,
Hope everything is fine.

Can anyone help me on "How to use All borders" option using VBA. It would be of great help.

My required cell starts from "A3" cell and Column will end at "Y" column (Column is fixed everytime). But the row number will be varying everytime. Row range might be 450 ,650 or any other number.

I want to apply border to every cell.

Font style = Calibri (Its fixed)
Font size = 11 (Its fixed)
Alignment = Centered (Horizontal and Vertical as well)

When I am trying to record Macro and run it, its working only for "A" and "B" column and for the rest of the columns (From "C" till "Y") its not working.

Attached is the excel for your reference.

Thanks in advance.