Recent content by Kanagat

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