Adding Conditional Formatting via VB

**Snickers** · 11-09-2010, 05:01 PM

I have a huge spreadsheet that I need to add conditional formatting, Right now I have it via the conditional formatting drop down and it makes the spreadsheet freeze and run slow,
I have three sets of colums that repeat Column 1, 2, 3, In the second column I have forecasted dates, below are the conditions that I'm trying to add

If column 2 is empty no formatting

Condition one: If there is a date in column 3 = no formating in column 2 end of formatting

Condition two: if column 3 is blank, and the the date in column 2 is less than today's date formatting = column 2 = red fill end of formatting

Condition three: if column 3 is blank and column 2 = today through today + 7 days formatting = column 2 = Yellow fill

Condition four: if column 3 is blank and column 2 = today +8 through today + 14 days formatting = column 2 = Yellow fill

Column 1 = Column "O'
Column 2 = Column "P"
Column 3 = Column "Q"

and the columns repeat until no more data.

Hope this makes sense.
Snickers

**davesexcel** · 11-09-2010, 09:19 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**Snickers** · 11-10-2010, 02:39 PM

I have included a sample worksheet and added labels at the top indicating:
Column 1 = Planned
Colulmn 2 = Forecasted
Column 3 = Actualized

I have a huge spreadsheet that I need to add conditional formatting, Right now I have it via the conditional formatting drop down and it makes the spreadsheet freeze and run slow,
I have three sets of colums that repeat Column 1, 2, 3, In the second column I have forecasted dates, below are the conditions that I'm trying to add

If column 2 is empty no formatting: Stop

Condition one: If there is a date in column 3 = no formating in column 2 end of formatting

Condition two: if column 3 is blank, and the the date in column 2 is less than today's date formatting = column 2 = red fill end of formatting

Condition three: if column 3 is blank and column 2 = today through today + 7 days formatting = column 2 = Yellow fill

Condition four: if column 3 is blank and column 2 = today +8 through today + 14 days formatting = column 2 = Yellow fill

Column 1 = Column "O'
Column 2 = Column "P"
Column 3 = Column "Q"

One condition that I didn't add was in column 1 Planned if the date is less than today and column 3 is blank, comlumn 1 should be red.

and the columns repeat until no more data.

Hope this makes sense.
Snickers