I understand that the sheet will be populated from Access, and you don't know
how to apply conditional formatting other than using VBA.

The easiest way to learn coding is to turn on the macro recorder and see hw
Excel does it. Having said that, its not always the prettiest piece of code.

Here's mine for you:

Sub SetCondFormat1()
With Columns("A:L")
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=OR($D1=""Customer"",$H1="""")"
.FormatConditions(1).Interior.ColorIndex = 36
End With
End Sub



"shairal" wrote:

I have a spreadsheet that is created once a week from an Access program. I
have recorded a macro that formats most of the data Im looking to change,
however I need to do some conditional formatting. Since I cannot save
Conditional Formatting rules in Excel, I need to do this in a macro and I
dont know enough about VBA to accomplish this on my own €¦ help please!

The spreadsheet is column A:L however it varies in row count each week.
Colum D is a text column and sometimes includes the word €˜Customer
somewhere in the cell €“ if it does, I want to highlight that cell in yellow
and give the entire row (A:L) a heavy border
Cells in column H, also a text column, are sometimes blank/empty €“ if a cell
blank, I want the entire row (A:L) highlighted in yellow with a heavy border

I have seen lots of If Then and Case examples, but I dont know how to make
them select a dynamic range, or highlight a single cell if one condition is
met, or an entire row if another condition is met.

Any help you can provide is greatly appreciated!