VBA conditional formatting coding in Excel!

Hi,
I have the following conditional formats:

=AND($J8>=N$4,$K8<=O$4,$I8=1) - turns cell green
=AND($J8>=N$4,$K8<=O$4,$I8=2) - turns cell red
=AND($J8>=N$4,$K8<=O$4,$I8=0) - turns cell black

but i need to add more so i need to use VBA coding!

Im a beginner at VBA so dont really have an idea of the coding needed!

Also, one point to note - i need these formulas to apply to a whole list of cells i.e. Cell rang L7:BO210 - so quite a lot of cells! And the values in the formulas change for each cell so for cell S13 for instance, the formulas would be:

=AND($J13>=S$4,$K13<=T$4,$I13=1) - again cell green
=AND($J13>=S$4,$K13<=T$4,$I13=2) - cell red
=AND($J13>=S$4,$K13<=T$4,$I3=0) - cell black

Any help would be great, thanks!!