正在加载视频...
视频加载失败
I’m giving away all my Excel secrets!
10 条评论

Okay but how do you do the color fill

Thank you for sharing our tips! We ask that you please credit our account, @The_CheatSheets, any time you repost one of our tips 😊

For those that might not know how to add the colour...👇🏽👇🏽 1. Select your range of cells that would need this information, then go to "Conditional Formatting", then click on "Highlight Cells Rules" 2. Click on "Text that Contains...", You'd see a dialogue box that says...

Thanks for this if function I normally use it

Do you perhaps have a YouTube channel where you can be followed?

See this number now can u teach me that how to remove front and last zero??

it is for single result, what about if each student have 5 subject's number in list and 2 subject's fail and 3 of subject pass , so how we can use formula to get result?

@GetVideoBot

@SaveVidBot

@SaveMyVideo
