Data Validation to VBA

[Src016]

Hi All!

I need to translate the following data validation rules to VBA:

Rule 1:
Cell does not contain: no blanks format - as white
-- stop as true

Rule 2:
=OR($J3="Pending - Please Elaborate in Notes")

as red


Both of these formatting rules apply to $K2 through $K1048576

I am generating templates and need this conditional to run within a sub that runs as soon as you open the workbook.

This would be a huge help!
Thanks
Spence

 

[6StringJazzer]

What you are describing is conditional formatting, not data validation.

Do you want VBA create these rules and add them to the sheet? Why not just put the rules right into the template, rather than running VBA to create them? Not clear on why you are looking to do this in VBA.