Conditional formatting to VBA

[justinwb]

Good afternoon everyone

I have started to look in to using VBA and it great I have been able to use forums and google to read up and then change the information to match my needs
for the life of me I cant work out how to convert conditional formatting to VBA I have looked up and there are work arounds when cutting cells and it all points back to using VBA and running it at the end of my shift and during the day to fixed all formatting up as we move a lot of data on the sheet

I just cant find any guides that I can follow
below are my formulas and any help with a website I can follow would be great or pointing me in to the right path

All are in black font size 11

Applies to	          rule type	                                   format
=$D$2:$K$63	=ISBLANK(D2)	                            White Fill
=$O$2:$Q$63	cell value greater then =0.125	       RED   Fill
=$O$2:$Q$63	cell value between  =0.001 & =0.125	Green  Fill
=$J$2:$J$63	=IF(J2-D2>TIME(0,30,0), 1, 0)	          Orange  Fill
=$D$2:$D$63	=IF(ABS(D2-C2)>TIME(0,30,0), 1, 0)	Orange  Fill
=$G$2:$G$63	=IF(G2-D2>TIME(0,30,0), 1, 0)	          Orange  Fill