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
acadgild.com/big-data/data-an...
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.
How to Highlight Cells Using Conditional Formatting: • How to Highlight Cells...
How to Format Cells in Excel Using Conditional Formatting: • How to Format Cells in...
How to Add Data Bars in Cells in Excel Using Conditional Formatting: • How to Add Data Bars i...
How to Use Color Scale in Excel Cells using Conditional Formatting: • How to Use Color Scale...
VLOOKUP and HLOOKUP Tutorials: • LOOKUP Tutorials in MS...
Please like, Share, comment and subscribe the channel for more videos.
For more updates on courses and tips follow us on:
Facebook: / acadgild
Twitter: / acadgild
LinkedIn: / acadgild

[@cnfcomps]

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

[@Fifth_Ace]

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

[@bikingbaker]

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

[@Acadgild]

Thanks a lot dear B en,
Please subscribe the channel for more videos

[@angrejiwala]

Same Dude...

[@sufiyankhan3365]

Thanks, its help me ❤❤❤

[@sumonahmed6283]

Lot of thanks

[@64mustangfan]

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

[@markobrien5899]

Thank you.

[@bigdatax6512]

you just save my jobs ,thanks

[@bigdatax6512]

and how we can change "False/True" " with another word ???just like example "i want change Macth or Not Match

[@apadanaforex4080]

Thanks! Short and to the point!

[@tollpark3832]

Clear and concise. Thank You.

[@nandakrishna2898]

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

[@ikmalafifi2858]

THANK YOU

[@hk_200k]

Thanks. It works on big pivot table as well!

[@ashishsharma4780]

Pawan lalwani sir thank u for this video

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

[@mohamedmadkour6926]

Thank you so much, very informative and clear.

[@jaganathmohapatra]

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

[@pjain31]

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

[@MeenaVarshneyML]

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

[@luckynoor1313]

Thanks

[@deepvedpathak2988]

thanks bro

[@ucmasambernath9439]

It helped me. Thank you

[@vivianaho]

THANK YOU!!!

[@amitkumar071584]

I am very satisfied with this video.

[@UShruPra]

Thank you for this video😊

[@Michael-je5bn]

F4 tip is very useful thanks

[@upendrasinghtanwar3943]

tnx sir.

[@sandippatel6999]

great

[@suryanarayandas976]

Thank you SIR.

[@zeinghaleb]

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

[@danmilka]

Thanks!

[@bprasanthkumar4303]

Very Nice..:)

[@raj8119]

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

[@raj8119]

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

[@JatinBujj]

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

[@anamikabharali678]

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

[@abhiseksingh4886]

It may probably be due to selection of array in index or vlookup.. u can elaborate ur query a bit or refer to a video on "off to office". It helped for my office work.

[@abhijithsuresh6358]

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

[@friendlytester6861]

Me too

[@UShruPra]

Thank you for this video😊

[@shubhammourya119]

Thanks