Search results

Thanks to one and all who supported me to solve my query. Now my logic is working fine. Thanks to everyone This is solved

Hi Hui, I extention to my last query, And in AX2 cell can i replace the values of 1,2 &3 with the color names like green, yellow red. - this particular thing is solved. now i want to know only about below mentioned query... like can i hide & lock the replicated cells like A2:AW2.

Hi Hui, Thanks for the extended help . The suggestion given by you is working. in addition to the same i need some more help, like can i hide & lock the replicated cells like A2:AW2. And in AX2 cell can i replace the values of 1,2 &3 with the color names like green, yellow red. Thanks...

Hi, Thanks for the continuous help Hui. I'll try out with formula given by you and get back to you....

Hi, Thanks for the suggestion. Actually i could not understand what nelson Wang said. As already i shared the sample template with you, can you please guide me in doing the same for the first entry(proj1) so that i can do it for the remaining. Thanks in advance.

Hi, I tried using UDF provided by you but unable to acheive the target. and am facing pblm in uploading file also...

Hi first of all thanks to narayan, hui (excel ninja) & nelsonwang. But each cell in my excel is having different validation and having 35 columns and 100 rows in a single work sheet, which is not possible to give manually....

I have an excel data in 10ten columns. Each column is defined with distinct conditional formatting respectively with Green, Red & Yellow colors. Now based on below mentioned rule i want 11th column to be color coded automatically. Green - If all the columns are green Yellow - If any one...