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

How to Compare 2 Columns in Excel Using Conditional Formatting | Advanced Conditional Formatting #1
Hello and welcome back to excel tutorials for beginners 2018 powered by Acadgild. In this excel tutorial video, you will be able to learn, How to work on advanced conditional formatting with an example, how to compare column values and highlight difference using conditional formatting
If you have missed the previous video, please watch the video by clicking following video link.

Please like, Share, comment and subscribe the channel for more videos.
For more updates on courses and tips follow us on:

[Ethanathan]

Thank you! Spent 30mins searching for the right video and yours was exactly what i was looking for

[vadddy]

Thanks for your video tutorial. After searching for videos on Conditional Formatting on YouTube for hours, I finally found your video, which taught me how to do what I needed to do, namely RAG (Red-Amber-Green) students' actual grades compared to their target grades.

[cnfcomps]

Many thanks this really helped me to show the differences between two columns of figures in Excel.

[mustangfan]

Great! I'd forgotten, you are straight to the point, thank you.

[hk_k]

Thanks. It works on big pivot table as well!

[pjain]

great piece of information ... keep up the good work

[Fifth_Ace]

Space X engineers would not have been able to succeed without Indian YouTube teachers. Let’s take a moment and be thankful

[mohamedmadkour]

Thank you so much, very informative and clear.

[zeinghaleb]

many thanks
W hate about if the value repeated to many in the same column ?

[nandakrishna]

Thank you. This function really saved me a lot of time❤❤. Keep it up!!

[jaiarya]

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 ?

[jaganathmohapatra]

You are awesome...I got what I want after an hour's search..love you

[raj]

Hi, it’s good but what if value decreases and how to change color of it

[MeenaVarshneyML]

Awesome...It helped me an amateur in excel, a lot

[ashishsharma]

Pawan lalwani sir thank u for this video

[raj]

Basically if it’s greater then color change and if it’s lower then color change

[JatinBujj]

How to know that how many numbers of corresponding data in column B is more than column C

[anamikabharali]

This didn't work with time stamps please help me out
One row above the cells satisfying the formula is getting selected

[abhijithsuresh]

With the first method it is just comparing against the first cell for me