Hi All,
i was found the formula will be changed as below screen cap after i setup in conditional formatting and run my marco, so i was thinking to use name manager to replace
can some one help or advice how can this be worked?
credit to "awoohaw" for the guidance on conditional formatting
=INDEX(DATA!$D$2:$D$150,MATCH($D2,DATA!$A$2:$A$150,0))="X"
i want the result return like below screen cap
thank you very much!!!
i was found the formula will be changed as below screen cap after i setup in conditional formatting and run my marco, so i was thinking to use name manager to replace
can some one help or advice how can this be worked?
credit to "awoohaw" for the guidance on conditional formatting
=INDEX(DATA!$D$2:$D$150,MATCH($D2,DATA!$A$2:$A$150,0))="X"
i want the result return like below screen cap
thank you very much!!!