VBA Macro Conditional Formatting
Closed
slohman
Posts
3
Registration date
Wednesday 26 March 2014
Status
Member
Last seen
2 April 2014
-
26 Mar 2014 à 01:39
slohman Posts 3 Registration date Wednesday 26 March 2014 Status Member Last seen 2 April 2014 - 2 Apr 2014 à 01:00
slohman Posts 3 Registration date Wednesday 26 March 2014 Status Member Last seen 2 April 2014 - 2 Apr 2014 à 01:00
Related:
- VBA Macro Conditional Formatting
- Excel clear formatting - Guide
- Vba find - Guide
- Excel conditional formatting based on date - Guide
- Vba case like - Guide
- Vba timer - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
26 Mar 2014 à 02:26
26 Mar 2014 à 02:26
try this macro
row 1 is header row
row 1 is header row
Option Compare Text
Sub test()
'assume row 1 is header row and no blank cells, blanks rows, blank columns
Dim r As Range, c As Range, j As Integer
Set r = Range(Range("A2"), Range("A2").End(xlDown))
For Each c In r
j = c.Row
If Cells(j, "A") = "Dial" And Cells(j, "F") = "Booked" Then
Range(Cells(j, "A"), Cells(j, "M")).Cells.Interior.ColorIndex = 5
End If
Next c
End Sub
slohman
Posts
3
Registration date
Wednesday 26 March 2014
Status
Member
Last seen
2 April 2014
26 Mar 2014 à 03:36
26 Mar 2014 à 03:36
Thank you so much for that it works great for the first one but yes there is blanks in columns and rows and cells and the Dial Before You Dig appears down a number of times in column A and also Booked is found more than once in column f and the date appears in j many times. Can it look for the word Dial with a wildcard attached.
slohman
Posts
3
Registration date
Wednesday 26 March 2014
Status
Member
Last seen
2 April 2014
2 Apr 2014 à 01:00
2 Apr 2014 à 01:00
Can anyone help with this??
