![conditional formatting excel youtube conditional formatting excel youtube](https://i.ytimg.com/vi/VhECzNIQTIY/maxresdefault.jpg)
![conditional formatting excel youtube conditional formatting excel youtube](https://i.ytimg.com/vi/Cv_OEnNzdnU/maxresdefault.jpg)
#Conditional formatting excel youtube code#
Now when we run this code using the F5 key or manually, we see that the marks that are less than 50 get highlighted in bold and red, while those that are greater than 80 get highlighted in bold and blue as follows: Font.Bold = True End With With condition2 'Defining and setting the format to be applied for each condition With condition1 'Defining and setting the criteria for each conditional format Set condition1 = (xlCellValue, xlGreater, "=80")
![conditional formatting excel youtube conditional formatting excel youtube](https://i.ytimg.com/vi/XXjrA2DOTuw/maxresdefault.jpg)
'To delete/clear any existing conditional formatting from the range 'Fixing/Setting the range on which conditional formatting is to be desired Set rng = Range("B2", "B11")
![conditional formatting excel youtube conditional formatting excel youtube](https://i.ytimg.com/vi/lQz4e2FCngM/hqdefault.jpg)
'Definining the variables: Dim rng As Range The objects created in this module can be used in any VBA project.
#Conditional formatting excel youtube download#
You can download this VBA Conditional Formatting Template here – VBA Conditional Formatting Template Example #1