Dear bro,
main yeh pochna chahta hon k main excel main eik work sheet main jis jis cell main sum ka formula hai us call main color karna chata hon with contitional formating
Dear bro,
main yeh pochna chahta hon k main excel main eik work sheet main jis jis cell main sum ka formula hai us call main color karna chata hon with contitional formating
Dear kia app ke kehny ka ye matlab hai ke AP Formula Show karna chahty hain... With Color...? Please apny Sawal ko Explain karin... Shukria....
Agar aap conditional formatting k zarya formula wale cells ko highlight karna chahte hain tu is k leye aap ko macro coding ki zaroorat ho ge (mere ilam k mutabiq) agar kisi aur dost ko koi tareeqa pata ho tu m bhee intrested hon.
Leekan agar aap ye chahte hain ka sheet me jo bhe formula ha unko color kar don tu is k leye tareeqa ye ha.
1. Press F5.
2. GOTO k menu m se special select Karain
3. New open hone wale window m "FORMULA" select karain
4. OK press karain aap notice karain ga k sheet m jahan bhee formula ha wohe cell select howe hain. Apne marze ki formatting select kar lain sirf unhe cells par apply ho ge jahan formula laga ha
hope this will help you.
regards
nice sharing..
conditional formatting mean agar paln valu yo hu tu paln color auto use ho,es ko kis tarha apply kya jata hy ,ws ka jawab share kari
Bookmarks