I'm exporting an Access report to Excel, and want to include the conditional formatting via VBA. The number of rows will vary depending on the underlying Access report criteria, so I've been using the .EntireColumn("B:B") syntax for most of my formatting efforts. But now I have a problem.
The color coding for column E depends on both the value in columns C and E
C E background Format
<250 <250 normal (this is the base case)
<250 >=250 light green
>=250 <250 light red
using VBA, how do I right the criteria expression so that I can do all of the conditional formatting for column E at one time, and don't have to do it one cell at a time.