Please help me solve my issue in excel.
I want to change color of the font to white automatically in excel wherever there is repetition or duplicate value within a column range. But I want the first word to be in black. The reason to make the duplicate one to be white because I dont want to show it visible but if you click on the cell, the value is still there.
Same issue but there are 2 or more cells repetition. Let say we have 5 same value text or number in five adjacent cells, I want 4 of them to be white, the topmost to retain as black or any color as long it is not white.
All data within that column are generated thru vlookup from another tab.This time I have 2-5 column range to consider.
Question1, Can I just do it using formula to input in formula bar?or it can be done only using vba?By te way im using 200t excel. If so, can you guide me to make equation for this please.
Thanking you in advance.