3 Easy Ways to Highlight Cells with Formulas in Excel

Рет қаралды 6,543

Күн бұрын

In this video, I will show you three simple ways to highlight cells in Excel that contain formulas.
This can be done using Conditional Formatting, Go To Special, or VBA methods.
00:00 Intro
00:28 Using Conditional Formatting
02:57 Using Go To Special
04:36 Using VBA
Read the article - trumpexcel.com/highlight-cell...
Personal Macro Workbook - • Personal Macro Workboo...
-------------------------------------------------------------------------------------------------------------
'Code developed by Sumit Bansal from trumpexcel.com
Sub HighlightCellsWithFormulas()
Dim rng As Range
Dim cell As Range
Set rng = Selection
' Loop through each cell in the range
For Each cell In rng
' Check if the cell contains a formula
If cell.HasFormula Then
' Highlight the cell with a yellow background color, change RGB values as desired
cell.Interior.Color = RGB(255, 255, 0)
End If
Next cell
End Sub
-------------------------------------------------------------------------------------------------------------
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 14

@trumpexcel 5 ай бұрын

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course

@IvanCortinas_ES 5 ай бұрын

A very complete tutorial. Thank you Sir!!

@tinasmith5530 5 ай бұрын

Thank you! I have been wanting to discover how to highlight with macros for a while. Very clear. Well done!

@TunisianSpring 5 ай бұрын

How amazing is the way your are explaining. A quite methodological approach, Thank you for everything.

@nadermounir8228 5 ай бұрын

Thank you Trump for this nice video 📹 👍

@Satwant2463 5 ай бұрын

Very well explained. Thank you.

@vishalbharakhada3357 5 ай бұрын

Awesome thank u so much

@ramruttunaubeeluck9235 5 ай бұрын

Sir Could you please tell me how Vba can be applied in Internal audit. Thanks

@KuldeepSingh-nq1vi 5 ай бұрын

Very Nice video Bro.. What is the use of DoEvent in VBA, please make a video on same.. Thanks

@razzakhan6409 5 ай бұрын

You are best

@benosborne413 5 ай бұрын

Great. I have a worksheet and at the end I have a drop down list with: "In Stock and Out of Stock:. I want to highlight the row when I select "Out of Stock".. Will I be able to do that?

@ankursharma6157 5 ай бұрын

Hi, You can do it using Conditional Formatting with Formulas. • Example: the dataset range is A1: F100. • Column#E contains the drop-down list. 1. Select range A2:F100. 2. Home tab --> Conditional Formatting drop-down --> New Rules A dialog box will open. 3. In the dialog box --> in the top half --> select the last option: "Use a formula to determine which cells to format". 4. In the bottom half . . type: = $E2 = "Out of Stock" 5. Click on the Format button to apply formatting. 6. Click O.K. . . and O.K. Hope, this helped.