How to Compare two Columns in Excel | Conditional Formatting Cells

#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.

[@evalinepoetsema9852]

Thank you! clear explanation and very helpful. (I keep wondering why I need to remove the dollar signs though)

[@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]

sorry i dont have, thanks

[@MyLightAA]

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]

Very simple trick and explanation. Thank you very much

[@HarithaComputersTechnology]

You are most welcome

[@ryang5986]

Thank you! This helped me do exactly what I needed to accomplish!

[@HarithaComputersTechnology]

Glad it helped!

[@5ajidMukhar1]

Big fan yar love you ❤

[@HarithaComputersTechnology]

Loved your comment one like for you !

[@eveandfreinds]

Helpful! Thanks!

[@HarithaComputersTechnology]

Glad it was helpful!

[@krishnapadyal5789]

Thank you ❤

[@HarithaComputersTechnology]

You're welcome 😊

[@nitdawg007]

Thank you for your help.

[@HarithaComputersTechnology]

You're welcome!

[@nkpeyada]

Thank you! Very helpful 👍👍

[@HarithaComputersTechnology]

Glad it was helpful!

[@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]

Please check my channel excel playlist you can find 100's of video. you can find there
ruclips.net/p/PL5smYbP6KikMPfb2Y9SKUw59SQB8MQo8Y

[@ericawilliams6202]

Very nice!

[@HarithaComputersTechnology]

Thanks