I need to apply some conditional formatting to a report that I am exporting from an Access database. It should be easy, but I can't figure out the exact phrasing. This is what I have now:
With oSheet.Range("A1:" & Chr(iNumCols + 64) & rs.RecordCount + 1)
If Range("A:A") = "BA-Lots of Stuff" Then
.Interior.Pattern = xlSolid
.Interior.PatternColorIndex = xlAutomatic
.Interior.ThemeColor = xlThemeColorDark1
I also tried having it as
If "BA-Lots of Stuff" = true then .... but that didn't work either.
Actually, nothing happens when I tried to run either version.