Search results

Somendra Misra / Narayan Thank you very much!!!

It doesnt work Narayan, i've tried to change the color (

Yes, thank you guys thats what i needed. But i cant see my entries Y/P/N they are not displayed (

Narayan, Data entry will be N/P/Y (for Q15-Q20) I've attached the file again, and it will change the color of C6 according to results )))

Narayan, thank you for your swift response. The problem is that inputs should be Y/P/N in the item section and that will trigger change of color in cell C6... This is the problem...

Maybe... to assign number to N=0, P=1, Y=2 let's say there will be 4 items that should be filled so we have maximum 8 and min 0

Good morning, Excel experts! I have question, i was trying to create some kind of checklist. I've attached the file so you can get familiar with... Basically it should calculate average of the score where the inputs will be Yes/partially/No and as the result of that average it should color one...

let me try )))

Format cells based on their value

Hi All, I have question actually task that i should perform. I was struggling to find out the solution for that. I've attached the spreadsheet with a precise example that i need. first we two worksheets named 1 and 2 for 1 is general where conditional formatting should be applied 2 where real...

Thank you, anyway. Well, i should be creating three chart in one. Yesterday was looking for that

Gurus in Excel :-) I need help, I've attached file with the description. Well i need to create chart (area) using information from 3 rows and i'm stuck to get in one area graph. Any suggestions are welcome. Regards, K

Guys, Need help, I need to create chart (line with markets) which will show me maturity levels. The Y axis will have 4 levels 1=> 2=> 3=> 4 The X axis will have timeline with years starting from 2012, 2013 ,2014, 2015 Data that should be filled 1) DRM 2012 will be equal to 2...

Hi Narayan, Thank you, it works. "I do not know what is supposed to happen if a task has 6 or more sub-tasks , since in this case , the total can go beyond either +100 or -100." Probably will divide 100 for 6 subtasks ))) Thanks a lot. Regards, Kanagat

Yes, you've got it! But if i will change one of the subtask lets say that it is completed then status should show 20 % of completed! Kanagat

Hi NARAYAN, Well i thought that I've uploaded new one, but it didn't save it oops! I have posted the data (in terms of data we have 4 options complete/late/ at risk/ on schedule) which is available on tab 1 for task 1 ; with reference to this specific data ( not in general ) , can you say...

Hi NARAYANK991 - Excel ninja ))) https://docs.google.com/file/d/0B88omcoE1QfnQXFUSmc2ZHZwM1U/edit?usp=sharing please a have a look...

Lets say it that way, to complete one task we have 5 sub tasks (Tab 1) For instance if one sub task status will be completed in tab 2 status of task will be 20% completed If all sub tasks will be completed then in tab 2 status of one task will be filled 100% Hopefully its clear now )))

Hi NARAYANK991 Here the link with an example https://docs.google.com/file/d/0B88omcoE1QfnYnlpeHJwMHFubnM/edit?usp=sharing And thank you ))

Hi Guru's of Excel, I have small project which consists of 5 phases with tasks to do (WBS). And I'm using Excel in order to manage it (challenging myself :-) ) Excel spreadsheet consists of 2 worksheets For instance: 1 worksheet (detailed) WBS 1 Status : Completed/ Late / at risk/ On...

Hi @NARAYANK991, Thank you for the solution ))). Its nice to have Forum like that! Again thanks @NARAYANK991 Best Regards, Kanagat

SirJB7 Thank you its working. You are true Excel GURU. Thanks man USSR )))

Hi SirJB7, Thank you for advice, in my case its huge file with some private information. It looks like that File Name Extension Size 1-Additional.pdf pdf 10582.0 2-Additional 1.pdf pdf 205822.0 3-Крутой файл #275.pdf pdf...

Hi guys/ladies, I have question, well i have huge list with pathes listed in worksheet, looks like that 2- Infrastructire & ServicesCAdmin & CControlContractsdocumentation2002-0674_Schedule A.pdf I need to find and count how many file names contains CYRILLIC characters in their structure...

Thank you Faseeh, I will try it )))