Substituting Conditional Formatting Code with VBA Macro

[e4excel]

Substituting Conditional Formatting Code with VBA Macro

Is it possible to Susbtitute Conditional Formatting with VBA Macro?
I need to desperately write a code in VBA but do not know how to implement the same..

AS in CF we write the codes for particular cells however they apply to a Range, so how to do the same in VBA ?

Warm Regards
e4excel

[tigeravatar]

e4excel,

I'm not sure why you would choose to use VBA over conditional formatting, but you can use the following as an example to get started. It looks at column A and any cell that is 0 it fills red. Make sure to put the code in the desired worksheet's Event module:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[e4excel]

Thanks for keeping my Hopes Alive TIger Avatar...

I will now post the actual file which has around 5 Conditions to get BORDERS around the filled Data Range..

For confidential reasons I cannot post the Main Data Sheet from where the Data is fed into this Sheet which needs to be distributed but without any conditional formating code.

The File I am going to attach for reference is just a structure of the original file in which the VBA Code OR ALTERNATIVELY if anything better can be added..

I have 5 Conditional Formatting condition with the help of which I get Borders aroungd my Data in the SHeet...

Condt 1 =AND($C2=" ",$C1>=1) Top Border


Condt 2 =AND($C2<>1,$C2>=$C1,$C2<>" ",$C3=" ") Dotted Top Border


Condt 3 =AND($C2=1,$C3>=$C2) Dotted Bottom Border


Condt 4 =$C2>1 Dotted Top & Bottom


Condt 5 =AND($C2>=1,OR($C3=" ",$C3=0)) Non-Dotted Square

There are 2 Colours DARK PURPLE and TAN...

The DARK PURPLE are the XLTHIN Borders and the TAN are the XLDOTTED borders.

PFA , please feel free to change the conditional formatting code if the need be but please help me with a VBA code....

Warm Regards
e4excel

[e4excel]

Dear Tiger,

Please check if this can be done via VBA.

Reg

[e4excel]

Bump NO Response