Use this SIMPLE TRICK to Highlight a Selected Row in Microsoft Excel

Показать описание

In this week’s training, I will show you how to highlight a selected row in any table in Excel.

⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:

EXCEL COURSES:

EXCEL PRODUCTS:

TIMESTAMPS:
0:00 - Introduction
0:58 - Conditional Formatting
4:48 - Selection Change Event

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #highlightselectedrow #exceltricks #rowhiglight

Рекомендации по теме

Комментарии

I love how you teach excel...I wish I had you for a teacher..I would have aced all my classes. You are awesome and you rock.

ilocomocomediaentertainmen

That was amazing! I wasn't even intimated by the VBA, complete stranger! Loved the way it was presented! Everything was clear and concise. You are a wonderful teacher! Thank

marcellejoubert

I can only echo the sentiments of many others who have watched and learned from this video. Your presentation skills are exceptional. Your step-by-step instruction was terrific. I struggled a little with the syntax as I am not familiar with VBA at all. I persevered and voila! Success. Thank you.

roberthunt

This is my second comment after I tried this on my own spreadsheet I am so grateful.. You are a star 🌟. 👍 Thumbs up..

sasavienne

Thank you Randy, sweet and short and to the point.

kwenahlako

Best ever use of conditional formating to higlight the row

unisoft

Thank you so much. I absolutely love this technique

liquidapathy

This is an amazing technique, I wanted to learn since a long time. You presented it in a clear and excellent way. Thanks indeed.

sasavienne

You are the best teacher out there, and thanks for the videos they very helpful and please keep us updated again Thanks

sduce

Thank you for this. its really a big help. I am actually using this trick right now. and my database did stood out. Big thanks.

CarMaestre

No importa a lo que te dediques hay dos cosas que debes aprender si o si: Ingles u Excel. No matter what your job is, there is two things you've to learn: Excel and English. This video was made a long time ago, and it still being useful. That's. I just meet you, and I've a lot of video to see in your channel. From Nicaragua (Central America) regard

rnunez

Respected Sir ! you are really one of the greatest teachers.

azizniazi

Thank you so much for this! So appreciative

nunyabusiness

I found out what was wrong, it needed to be Saved Macro Enabled Thanks it now works like a charm

defenderoff-road

This was a very good video. Simple way to highlight the row or column. Great work and good explanation.

mohanpuri

Wow! I did my first vba today and it works perfectly!!! Thanks so much for your videos, I really appreciate them, they are improving signifficantly my excel knowledge.

carmela

Hi Randy.. great tip.. I just came across this video. Here is a method that I have used in the past. Do the same Conditional Formatting as in your video, but using the formula: =CELL("row") = ROW(). Then, the command for the Worksheet_SelectionChange event becomes: ActiveSheet.Calculate. This avoids the need of referencing a cell for the row reference from the face of the worksheet. It is just another way to get it done. I do like your method, as I think it produces less calculation overhead which might slow performance on a complicated workbook. I use my method on simple lists where performance is not an issue. For complicated workbooks, I'll definitely give your method a try in the future. Thanks for expanding my knowledge. Thumbs up!

wayneedmondson

Thank you for this! It was helpful for a newbie like me

piterfinacze

thank you for this video it was very helpful

arthurstuartleo

Very helpful. Thank you for your study.

ToanNguyen-lbfv

Use this SIMPLE TRICK to Highlight a Selected Row in Microsoft Excel

Use This Simple Trick to Put Your Duvet Cover On

USE THIS SIMPLE TRICK - Fortnite Tips and Tricks

Pros Use This Simple Trick To Defend

How To Complete ( Demon Hunter ) 20 Kills | Best Trick Complete So Easy | PUBGM

Reach MORE Frets Instantly Using this SIMPLE Trick (any hand size)

The Simple Trick to a Perfect Bleed & Lever Feel on Magura Brakes • The Duke of MTB

1 Simple Trick to Become Fluent in English - the JAM Technique - How to Be a Confident Speaker

Learn a SUPER EASY Self-Working Card Trick

Get the PERFECT Mustache Lip-line Every Time with This Simple Trick

Use this SIMPLE TRICK to Highlight a Selected Row in Microsoft Excel

Use This Simple Trick to Determine Whether an Avocado Is Ripe Inside

Use THIS simple trick to make your BATHROOM smell AMAZING!! ⚡

A Simple Trick to Get Into Your Car If You Locked Your Keys Inside

Use This SIMPLE Trick When Building a Blues Solo

Simple Trick to protect your Raspberry SD card from Crashing

Cups and Balls - Easy Magic Trick #cupsandballs #easymagictrick #cupsandballstutorial

Visual COIN TRICK - TUTORIAL | TheRussianGenius

Trick To Always Remember Your Times Table (6 to 10)

USE THIS SIMPLE TRICK TO GET CAR BATERIES AND ENGINES JUNKYARD RAIDER EDITION Last Day on Earth.

TRY This SIMPLE Trick to Build Curved Flanges for Inner Structures!! (Hammer Forming + Dimple Die)

NO SETUP Card Trick That FOOLS Everyone!

4of5 - Use this simple Trick to exclude 1 march from select-all - Rise of Kingdoms ROK Fleisch

The Simple Trick To Send Deadly Through Balls

Use this simple trick to make the best Chicken Noodle Soup of your life, Try it Today!