hello,
I want to design a whole line duplicate entries
And bases have duplicate entries design only one column.
What do I need to set to succeed to design a whole line
According double value in one column which I'll define it
Thank you
Don't know if I understand you well.
You have your input in column A and want the same values in columns B, C, D, E and so on? Then: (in B2): =A2 and copy that down and to the right.
But that sounds too simple, so I'm afraid you mean something else? Can you show what you want in an Excel file?
Thanks
I have attached the file
And painted the line that the code manually repeated in column A
I want to set conditional formatting rule
It will examine only whether the figure in column A is repeated
If so automated that will shape the line.
Hi lea
See the attachment.
One uses a helper column and the other uses formulas in the conditional formatting itself.
Both will detect duplicates/triplicates etc.
Hope this helps.
Sunny
