VBA conditional formatting coding in Excel!

Closed
firsttimer Posts 3 Registration date Sunday September 6, 2009 Status Member Last seen September 8, 2009 - Sep 7, 2009 at 04:54 AM
firsttimer Posts 3 Registration date Sunday September 6, 2009 Status Member Last seen September 8, 2009 - Sep 7, 2009 at 06:54 AM
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!!

2 replies

firsttimer Posts 3 Registration date Sunday September 6, 2009 Status Member Last seen September 8, 2009 1
Sep 7, 2009 at 06:54 AM
Hi but i need the formula to change for every cell and there are over a 1000 cells...the site doesnt explain how to cater for this..

thank you for you reponse though
1
Blocked Profile
Sep 7, 2009 at 06:33 AM
hi there,

follow the steps on this link:

https://www.ozgrid.com/VBA/excel-conditional-formatting-limit.htm

thanks
0