Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704.

preview_player
Показать описание
Use conditional formatting to format column A when the value in column Z is the same value as in the A column.
  1. excelisfun
  2. Excel
  3. Highline College
  4. Mike Girvin
  5. excelisfun
  6. excel is fun
Рекомендации по теме
Conditionally Format When 0:01:51

Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704.

Conditionally Format When 0:01:27

Conditionally Format When Two Columns have Same Value | Excel trick 2

Excel Conditional Formatting 0:01:30

Excel Conditional Formatting based on Another Cell | Highlight Cells

Find & Highlight 0:02:19

Find & Highlight Duplicates Across Multiple Columns Using Conditional Formatting

COMPARE TWO COLUMNS 0:01:58

COMPARE TWO COLUMNS USING DUPLICATE CELLS CONDITIONAL FORMATTING IN MS-EXCEL

How to Compare 0:08:01

How to Compare 2 Columns in Excel Using Conditional Formatting | Advanced Conditional Formatting #1

Excel How To: 0:09:29

Excel How To: Format Cells Based on Another Cell Value with Conditional Formatting

Compare Two Columns 0:06:17

Compare Two Columns in Excel (for Matches & Differences)

Use a COUNTIF 0:00:32

Use a COUNTIF Formula and Conditional Formatting to Compare Two Lists in Excel

Excel compare two 0:01:58

Excel compare two columns with conditional formatting

Conditional Formatting Formulas 0:04:25

Conditional Formatting Formulas - Mystery Solved with 3 Simple Rules

Conditional Formatting in 0:06:43

Conditional Formatting in Excel Tutorial

How to Compare 0:12:11

How to Compare two Columns in Excel | Conditional Formatting Cells

Excel Conditional Formatting 0:09:40

Excel Conditional Formatting with Formula | Highlight Rows based on a cell value

How to highlight 0:01:43

How to highlight values that appear in two columns | Compare Two Columns in Excel for Matches

Find Common Values 0:00:39

Find Common Values From Two List In Excel @BrainUpp

How to: Use 0:00:27

How to: Use Conditional Formatting Rules in Sheets

Compare two tables 0:04:26

Compare two tables | Highlights any missmatch by Conditional formatting in excel

Conditional Formatting with 0:06:18

Conditional Formatting with Multiple Conditions in Excel

Excel Conditional Format 0:09:38

Excel Conditional Format Icon Set to Compare 2 Columns

Conditional Formatting Based 0:00:21

Conditional Formatting Based on Another Column in Microsoft Excel

Excel Conditional Formatting 0:04:38

Excel Conditional Formatting Icon Set Compare 2 Column Cell Based on Other Value Accounting Report

Compare Two Columns 0:03:34

Compare Two Columns in Google Sheets and Highlight Differences Using Conditional Formatting

How To Separate 0:00:32

How To Separate Data Columns wise / text to columns #shorts #excel #msexcel #exceltutorial #viral

Комментарии
Автор

I love Excel's conditional formatting when it comes to comparing two tables, thanks for this great video 🙏🙏🙏

ogwalfrancis
Автор

Boom!The Power Of Conditional Formatting, Awesome Tool...Thank You Mike :)

darrylmorgan
Автор

EXCELlent magic trick! Now I know something additional about excel and only took me ~one minute. Saludos 🇲🇽

raitup
Автор

My fav conditional formatting! Thanks for sharing, Mike!

MalinaC
Автор

Great video Mike, I live in the south so when you said “Rig” I knew exactly what you was referring to because I used to work in the oil industry!!

anthonyverdin
Автор

Great tutorial for people who are in a hurry 🎉. Well done 👍

kennethultimate
Автор

Hi Mike. Great one! Thanks for the reminder of the options in the drop down. I always seem to default to building my own rule, as in: CF >> New Rule >> Use a formula >> =A2=Z2. Need to remember to use the built-in options when available. Good tip :)) Thumbs up!!

wayneedmondson
Автор

Thanks Mike.
Conditional Formating is awesome.

sasavienne
Автор

Wow!!! I was stuck on this for quiet some time! Thanking for the tip Mike!

celia
Автор

Thanks Mike for the "quick and easy" tips. Enjoy your Thanksgiving.

mattschoular
Автор

so much faster than other videos. thanks

Zandor
Автор

You always put up useful videos and many of them helped me a lot at work. Thank you so much! Have a wonderful Thanksgiving.

tomjun
Автор

Thanks Mike for another great video. Have a nice Saturday :)

nimrodzik
Автор

Came to my rescue once again that man!

garethwoodall
Автор

Liked and Thumbs Up....

Thank You Sirji...
Have Fun!!

maheshvinchhi
Автор

hija, after watching the video 5 times, I finally understood :D can I make the empty blocks no fill at all with colour please?

mitchrunner
Автор

Wow Sir thank u so much, in searching this method for long time, thank u so much for this wonderful video 👍

ArmanKhan-iqji
Автор

Hi, Sir
Outstanding conditional formatting.

abhishek
Автор

What if the column A cell has same cell in column z but not in same parallel cell.
How to highlight it then?

san_rawat
Автор

Please make a video on how to vlookup through multiple sheets,
bassicaly the "table" argument is split through multiple sheets. Thanks.

srulyfasten