How to Compare two Columns in Excel | Conditional Formatting Cells

  Рет қаралды 18,941

Haritha Computers & Technology

Жыл бұрын

#condtionalformatting #comparecolumns
How to Compare two Columns in Excel | Conditional Formatting Cells
Excel cells compare between two columns and apply styles to the cell colors using conditional formatting check if it greater, smaller and equals
Learn how to enhance your Excel skills with this comprehensive tutorial. Explore conditional formatting techniques to highlight cells based on specific criteria. Discover the step-by-step process of comparing columns in Excel, whether it's highlighting cells between two columns or comparing multiple cells simultaneously. This beginner-friendly guide covers various versions including Excel 2016 and 2018, providing valuable insights for efficient data analysis. Elevate your proficiency in Microsoft Excel through this user-friendly training resource focused on conditional formatting and column comparison.
In excel , how to compare 2 columns cells and highlight using the conditional formatting, this tutorial is MS-Excel beginners who are looking to learn for best excel training course haritha computers and technology is the perfect channel on excel courses. Now, lets find out how to highlight the cells when comparing between two columns using conditionally format excel formula.
We dont need any prior experience in excel, just you can learn this excel tips just watching this tutorial.

Пікірлер: 22
@evalinepoetsema9852
@evalinepoetsema9852 Ай бұрын
Thank you! clear explanation and very helpful. (I keep wondering why I need to remove the dollar signs though)
@eveandfreinds
@eveandfreinds 7 ай бұрын
Helpful! Thanks!
@HarithaComputersTechnology
@HarithaComputersTechnology 7 ай бұрын
Glad it was helpful!
@MyLightAA
@MyLightAA 3 ай бұрын
Thanks for help! I can't belive that stupid excel not have option for such simple function. Mark larger colum between colums and done!
@filbertjeremia3548
@filbertjeremia3548 4 ай бұрын
Very simple trick and explanation. Thank you very much
@HarithaComputersTechnology
@HarithaComputersTechnology 4 ай бұрын
You are most welcome
@ryang5986
@ryang5986 8 ай бұрын
Thank you! This helped me do exactly what I needed to accomplish!
@HarithaComputersTechnology
@HarithaComputersTechnology 8 ай бұрын
Glad it helped!
@nkpeyada
@nkpeyada 8 ай бұрын
Thank you! Very helpful 👍👍
@HarithaComputersTechnology
@HarithaComputersTechnology 8 ай бұрын
Glad it was helpful!
@nitdawg007
@nitdawg007 3 ай бұрын
Thank you for your help.
@HarithaComputersTechnology
@HarithaComputersTechnology 3 ай бұрын
You're welcome!
@ericawilliams6202
@ericawilliams6202 4 ай бұрын
Very nice!
@HarithaComputersTechnology
@HarithaComputersTechnology 4 ай бұрын
Thanks
@krishnapadyal5789
@krishnapadyal5789 3 ай бұрын
Thank you ❤
@HarithaComputersTechnology
@HarithaComputersTechnology 3 ай бұрын
You're welcome 😊
@jaiarya2399
@jaiarya2399 Ай бұрын
Thank you sir for this useful tutorial video .. But I have one more query.. How can we do same thing on GGOGLE SPREAD SHEET.. Do you have any video for this also ?
@HarithaComputersTechnology
@HarithaComputersTechnology Ай бұрын
sorry i dont have, thanks
@5ajidMukhar1
@5ajidMukhar1 3 ай бұрын
Big fan yar love you ❤
@HarithaComputersTechnology
@HarithaComputersTechnology 3 ай бұрын
Loved your comment one like for you !
@rahuldhavale9320
@rahuldhavale9320 Ай бұрын
Sir suppose b3 value compare c2 value max or min pls formula bata dijiye. Aur ye b rows mai sabhi ko aaply kaise kare .b3 ka c2 and b4 ka c3 aise hi b rows mai sabhi ka value
@HarithaComputersTechnology
@HarithaComputersTechnology Ай бұрын
Please check my channel excel playlist you can find 100's of video. you can find there kzfaq.info/sun/PL5smYbP6KikMPfb2Y9SKUw59SQB8MQo8Y
🤔Какой Орган самый длинный ? #shorts
00:42
IQ Level: 10000
00:10
Younes Zarou
Рет қаралды 9 МЛН
Red❤️+Green💚=
00:38
ISSEI / いっせい
Рет қаралды 86 МЛН
Получилось у Миланы?😂
00:13
ХАБИБ
Рет қаралды 4,5 МЛН
🤔Какой Орган самый длинный ? #shorts
00:42