Nice video. What if I had a list of customer account numbers and active and inactive statuses. How would I use Excel to quickly find out who the current customers are without counting customers multiple times because every status change is an additional entry.
Christmas background music is so pleasant. May God bless you. Merry Christmas. 2023 on Dec 25 Sunday. "Thanks for your explanation".
Thanks Rajan . Glad to hear that 😎
@@rajaniravi5685 Son of Britishers ..who killed our freedom fighters ..shame on you people
Thank you Brother😇😇😇😇😇🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻it helped me for my tomorrow's ICT exam......
THE COLORS pls. How to automatically convert collors.
Thanks to you for this video because this helped me for my exams 😊
😎
Thank you it is very helpful and also love the back around music😊❤❤
Welcome Marianne 🤗
@@DigitalELearning How did you get the color red in there if fail and green if pass?
Thank you for this! How did you get everything to fill in automatically at the end?
Move the arrow on John row and select shift+ up arrow then use ctrl+d the formula will derived the empty cell's.
Aapne cell color kaise change kiya
How did you color code the if statements?
Conditional formatting tool
Yes it is conditional formatting
Aise phlj baar hai koi background music kaan mae irritate nhi kr rha hai ..nice
How you colour this cells in if function
Conditional formatting
you can do it manually too
@@Sam_005 brother late ho gya btane mein aab to job se fire kr diya 🤡
Thank u so much..
Welcome 😊
How you filled up color based on pass and fail
Using conditional formatting
Pls explain that
such a pleasent way to understand ❤❤
Sir maine 1000 like kya.
Thanks 😎
How do you add to formula to return blank if score is empty?
@@josephjrafundar9899 blank is two comma or apostrophe
@@josephjrafundar9899 blank is two comma or apostrophe
Very nice sir❤
Keep watching
Lovely music 💖
Thanks
How it took the order to make fail in red and pass in green
Use "conditional formatting" from home bar
Very nice
Thanks
Nice video. What if I had a list of customer account numbers and active and inactive statuses. How would I use Excel to quickly find out who the current customers are without counting customers multiple times because every status change is an additional entry.
Thank you bhai
Very helpful 😊😊😊
Welcome 😊
Bhai aapne
Green or Red color kese diya
How colourS in come 😢pleaSe explain
Conditional formatting
How to get clr difference
Thank you so much ❤
Vo to smj gaya but true false me colour kaise dale?
Good simple thanks sir
Always welcome 😊
Thanks🌹..
Sir how Excel got red and green colour
🙏🙏 spectacular
Thanks
@@DigitalELearning to 👍🥳
If 6 subject is there?
Can add the same formulae for each subject column wise
Joy to the world the jessus says 😊😊😊
E3>=40 please explain 35 and 40 why are you put 35 and 40 which number is pass
joy to the world 😌😌
How u add red to fail and green to pass
Condition formatting me text that contain wala option use kro
Thanks sir like chesanu and subscribe chesanu
How came colour different from coloum
Conditional formatting
Why did E3 use ...
How Pass shows in Red colour and Fail shows in Green colour?
Please reply
It's seems they've applied the conditional formatting before the formula itself.
Its conditioning formating
There is separate video on conditional formatting on my UA-cam channel
ouu
Ye drag karne par color kaise aaya
Conditional formatting
Sir Aisa koi formula nahi hai jo data ke + - find kare
Awesome
Thanks Selvan
I confused both numbers because both pass number
Mine is not working. Doing same as you
Mere leptop me nahi ho raha hai
Same
I strongly believe you love and know Jesus...
I love dear, lets keep Loving Jesus till we see Him.
Thanks
👍👍👍
Thanks
Thik se nhi dikha adhaa toh bahar gya formula
Not alike
wrong
Fake
Teacher is not merciful
Thank you so much😊
You're welcome 😊
Very nice sir ❤
How the cell color changes red and green
Conditional formatting
@@LiveYoungLiveFree2022 k