Josecarlospdcj
New Member
- Joined
- Sep 1, 2023
- Messages
- 6
- Office Version
- 2010
class=y2iqfc>Hello everybody!
style='font-size:12.0pt;font-family:"inherit",serif;color:#202124;mso-ansi-language:
EN'>
I'm a beginner in VBA. I tried to change the code that is being shown in "VBA - highlight cells with absolute references" but I couldn't adapt to what I need.
style='font-size:12.0pt;font-family:"inherit",serif;color:#202124;mso-ansi-language:
EN'>I have a spreadsheet with more than 1000 cells in which there are formulas with variations between relative and/or mixed and/or absolute references.
style='font-size:12.0pt;font-family:"inherit",serif;color:#202124;mso-ansi-language:
EN'>I need to highlight in red only those cells that have at least one formula with mixed reference, regardless of whether this same cell also has, along with the mixed reference, formulas with relative and/or absolute references.style='font-size:12.0pt;font-family:"inherit",serif;color:#202124'>
The most recent attempt also did not work because it paints red only the 1st cell with a dollar sign, not differentiating those that have mixed and/or absolute references.
Dim r As Range
Worksheets("Plan1k").Activate
With ActiveSheet.UsedRange
.Interior.ColorIndex = xlNone
Range("A1:A16").Find(What:="$").Interior.ColorIndex = 3
End With
End Sub
style='font-size:12.0pt;font-family:"inherit",serif;color:#202124;mso-ansi-language:
EN'>
I'm a beginner in VBA. I tried to change the code that is being shown in "VBA - highlight cells with absolute references" but I couldn't adapt to what I need.
style='font-size:12.0pt;font-family:"inherit",serif;color:#202124;mso-ansi-language:
EN'>I have a spreadsheet with more than 1000 cells in which there are formulas with variations between relative and/or mixed and/or absolute references.
style='font-size:12.0pt;font-family:"inherit",serif;color:#202124;mso-ansi-language:
EN'>I need to highlight in red only those cells that have at least one formula with mixed reference, regardless of whether this same cell also has, along with the mixed reference, formulas with relative and/or absolute references.style='font-size:12.0pt;font-family:"inherit",serif;color:#202124'>
The most recent attempt also did not work because it paints red only the 1st cell with a dollar sign, not differentiating those that have mixed and/or absolute references.
Dim r As Range
Worksheets("Plan1k").Activate
With ActiveSheet.UsedRange
.Interior.ColorIndex = xlNone
Range("A1:A16").Find(What:="$").Interior.ColorIndex = 3
End With
End Sub