Learn Excel VBA - Conditional Formatting in 5mins [2021]✨

[@daviscara6831]

This video with a louder sound. Also the codes much more readable now. Thank you!

[@ErikMedia]

Thank you again for your support and feedback. Please do let me know what topics you would like me to cover also.

[@sheridiane5393]

Good stuff Erik. Thank you.

[@ErikMedia]

Thank you Sheri, I'm glad you enjoyed it and hope it helps you. Let me know if you have any questions.

[@joseenciso9099]

Awesome!! That's going to be very helpful, my colleagues keep breaking the conditional formatting

[@ErikMedia]

I'm glad this will help you. Thank you for supporting my channel.

[@mujuw]

Thank you for this helpful video. How would I apply the conditional formatting to rows where D = United States & C = Andria?

[@jxflash]

Very useful tutorial, And thanks that you explained why you need last row (but I wonder if it counts every column or only first?) I think this is only way to prevent duplicating and mismatch conditional formatting (CF) rules when you must copy/paste between areas with different CF. Can you explain in which event in VBA should I put this function to work automatically like traditional CF? Maybe "Worksheet_SelectionChange"?

[@ErikMedia]

That's some good question, will do my best to answer them. 1) I didn't explain the entire code for defining the last row. You will notice that after "rows.count," there is a number, this represents the column number, so in this case it is referring to column A. 2) Are you referring to when the sheet gets edited/modified and/or new rows are added? In this case you can use the worksheet change event and the range used in the "with sheet" would need to be larger to ensure you capture any additional rows.

[@jxflash]

@@ErikMedia Thanks Erik Is there any event which is called when you "paste" something or "drag with mouse" some cells?

[@ErikMedia]

Hi @jxfladh, You could do something like this, where if someone clicks on a specific cell, then another cell(or range) would be cleared or whatever you want it to do. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim reg As Range, abc As Range Set reg = Range("D2") Set abc = Range("E2") If Target.Address = reg.Address Then abc.ClearContents End If End Sub

[@boovank]

Do you have any Partial text match

[@ErikMedia]

Hey sorry for the late reply. You can try to use the xl:=Contains criteria or use a wildcard (*)

[@keithmcgee1253]

Can you have multiple conditions?

[@ubaidillahmuhammad20]

please just put in the description ,