Automatically highlight selected Row in excel | Excel Tips and tricks |
ฝัง
- เผยแพร่เมื่อ 17 พ.ย. 2022
- Link to more TH-cam Shorts videos:
Excel - Magic Tricks: • Excel - Magic Tricks
Excel - Advanced Sorting: • Excel - Advanced Sorting
Excel - Conditional Formatting: • Excel - Conditional Fo...
Excel - Functions: • Excel - Functions
Excel-Lookup: • Excel-Lookup
Excel - Dashboard and Visualization: • Excel - Dashboard and ...
Excel-Charts: • Excel-Charts
Excel - Shortcut: • Excel - Shortcut
Excel-Date And Time: • Excel-Date And Time
Excel - Dynamic Array Functions: • Excel - Dynamic Array ...
Excel - Formatting: • Excel - Number Formatting
Excel - Data validation: • Excel - Data validation
Excel - Text Functions: • Excel - Text Functions
Excel - PivotTable: • Excel - PivotTable
Excel - VBA: • Excel - VBA
Excel - Power Query: • Excel - Power Query
#excel
#exceltipsandtricks
#exceltutorial
#exceltips
#shorts
Song: Luke Bergs & MBB - Poolside
Music provided by Vlog No Copyright Music.
Video Link: • Luke Bergs & MBB - Poo...
Superb ❤❤❤❤
Just the "WOW" 😂❤
How to reverse it??
Super,
Please upload more videos ✨
thanks
I will try my best to upload more
Wow❤️
Target.calculate
Nice trick
Sangat bermanfaat
@BehnamTirabadi how to do it in Sheets
Excellent
Thanks🙂
Thank you Behnam! :D
My pleasure 😊
working, thanks buddy
You're welcome!😉
Hi sir! Can you show us how to auto highlights when I put ok words on my row at remarks?
Can you make a rule that does NOT highlight cells which are already filled?
❤
Row()=cell("row")
I have applied this conditional formatting and it worked. When the same file I shared via email or any other mode the conditional formatting was not visible
How can this be stored so whne the file shared to someone else, the conditional formatting is in place
I've done. Its. Super tricky...
Good 🙂
It really works 😊
Alt+ F11 is not working in my case
what is language of your Excel?
👍🙂
@@BehnamTirabadi Google sheet
Working but it can't be saved
How to apply this to entire workbook?
How can we highlight multiple rows?
And what is the purpose of this rule? Sori I'm a bit slow
Mere pass no. Kafhi data Rahat hai usko copy krke ek. ek nex application past Krna padta hai.. Mai bar bar bhul jata hu ki isko copy kiya ki nhi.. aap log niveden hai ki Aisa ko trick batye isko copy krne ke colour aa jye aur mujhe yad rahe ki isko copy kiya hai ...... Plz plz help kijiye
Some time your excell not show the page, worksheet. If you press left mouse button on top of sheet tab and click of view code then the worksheet sheet can select to type 'Target'
I can't see the view code
@@gladysperez2064
I have same issue
We're u able to figure it out, Please do share
If you have a TH-cam Link showing how would be very Helpful
Thanks
How to remove this. Its getting slower
Can you make rule that highlights active cell's row and column both?
Use this:
=OR(cell("col")=column(),cell("row")=row())
@@BehnamTirabadi thank you so much! It works
Happy to help
super, How you convert pc screen to shorts video size
I record only part of the screen at first place
Why some columns after clicking it does not highlight
It does not stop this from function still, I just have to click other columns. Just curious why is this so
Is this for the 365 version only? Or will it work in Excel 2016?
Work on all version
Is there anyway how to do this in google sheet?
Yes see this video: th-cam.com/video/5c29W6jEcog/w-d-xo.htmlsi=GOd6LZ-1S2AjtCgU
Hello
How can I do like that for each single cell
Hi
use this formula in conditional formatting
=AND(ROW()=CELL("ROW"),COLUMN()=CELL("COL"))
I use this alot in my programs but Ctrl+Z will not work in case you need to go back a step or few...
thanks for your feedback
i will keep it in mind
I am not able to save it if I save then this and reopen this sheet this formula gets useless again I have to apply. Please make a compalete video on this. how to store this formula and save both.
If you save your file as MACRO ENABLED WORKBOOK, you can save the process.
To do this go to File then Save as and in the pop up menu where you specify the location of you file in bottom of the pop up menu in Save as type choose "Excel Macro-Enabled Workbook"
Now every time you open the file if you active SECURITY WARNING ( apear in top of formula bar in yellow bar) all thing will work
How to remove this function from the excel sheet?
Select the area that you applied the conditional formatting and then go to HOME → Conditional Formatting → Clear Rules → Clear Rules from selected cells
I can't do this in google sheet.
How to deactivate it i am stuck 😮😮😮😢😢
It doesn't work at my PC 😢
Why I can’t take Alt+ F11 ?
Hold Alt then press F11
if that didn't work let me know
@@BehnamTirabadinot working sir
in windows 11 there is no alt +11 .. what will I do?
(473) How to Start Using VBA | Enable Visual Basic in Excel | Get Developer Tab | Programming in Excel - TH-cam
same as yours
It's not getting save without using macro
yes that's required.
How to delete that formula??
Go to Home tab , select Conditional Formatting in the open menu select Manages Rules, in new window Set "Show formatting rules for" to " this worksheet" and finally select your Rule and select "Delete Rule"
But u can't save it, right? , when u save it doesn't work like before
If you save your file as MACRO ENABLED WORKBOOK, you can save the process.
To do this go to File then Save as and in the pop up menu where you specify the location of you file in bottom of the pop up menu in Save as type choose "Excel Macro-Enabled Workbook"
Now every time you open the file if you active SECURITY WARNING ( apear in top of formula bar in yellow bar) all thing will work
@@BehnamTirabadi thanks, it worked
Happy to help 😀😀😀
Only works for the row I was going n when created the condition????
Forgot to Ctrl +A at beginning….works great!!!!!
@@kimberlyc.7303 Happy to hear 😀
If you want to highlight column too use this
=OR(cell("col")=column(),cell("row")=row())
Not working
hi
🙋♂️
not working
It doesnt work
Does your data looks like mine in first place