Sir wanted to know in conditional formatting how can we add colour time wise. Like in 12pm report < 50 % i need in red colour. At 1 pm it should red below 65 % . Kindly suggest me ASAP. there are 2 condition time wise and percentage wise.
It can be done with conditional formatting's " use a Formula to format cells " feature. i have already made a video on this topic, you can see it on my website www.myelesson.org
Hello sir Sir mujhe janna hai ki 1, Multiple sheet ke data ki last row ki value kisi dusri sheet (master sheet) par show ho 2, jab jab data update kiya jaye tab tab uss sheet ki last row value master sheet par bhi update ho jaye (pehle wali value se replace ho jaye)
Dear Sir,
You all videos are too good and because of that I learnt more in Excel.
Thanks for enhancing my knowledge.
Thank you for the kind words, you can see more of my videos and get free files from my website www.myelesson.org
I always like your style of teaching and easy understandable English language
Thanks Dost.
I am a girl....
Btw now m big fan of You sir your voice is so Good....Today i spent aprx 4hr in Your videos 😁
Thank you for the kind words, you can see more of my videos and get free files from my website www.myelesson.org
Love your videos
From uttarakhand
Than you Dost. I lived in Uttarakhand for more than 20 years. Its a beautiful place
My E-Lesson yes where do your place
Thank you for the kind words, you can see more of my videos and get free files from my website www.myelesson.org
My E-Lesson welcome sir ji
I was in Dehradun, did my schooling from there.
Sir make a vdo - interview question for fresher plz.... 🙏
Can u start making a video series on charts & graph :)
Hehehe, sure
Sir wanted to know in conditional formatting how can we add colour time wise. Like in 12pm report < 50 % i need in red colour. At 1 pm it should red below 65 % . Kindly suggest me ASAP. there are 2 condition time wise and percentage wise.
It can be done with conditional formatting's " use a Formula to format cells " feature. i have already made a video on this topic, you can see it on my website www.myelesson.org
My E-Lesson thank-you for quick response. 👍👍👍🏼
Hello sir
Sir mujhe janna hai ki
1, Multiple sheet ke data ki last row ki value kisi dusri sheet (master sheet) par show ho
2, jab jab data update kiya jaye tab tab uss sheet ki last row value master sheet par bhi update ho jaye (pehle wali value se replace ho jaye)
I want to learn from basic video, would you like uploading in serial numbers.
Sir ji saa aagya...( Y)
Thank you for the kind words, you can see more of my videos and get free files from my website www.myelesson.org
why you subtracted from 110 instead 100?
Sir whts Your website name ?
www.myelesson.org is my website
My E-Lesson okay sir. Thank you for quick response
Sir please to join your channel.
Welcome Dost
Thank you Dalip Thakur for the kind words, you can see more of my videos and get free files from my website www.myelesson.org
I watched this video you write 96 and the circle still closed
But if you write 99% or 98 you can't see the diffrence
It would show