VBA conditional formatting coding in Excel! [Closed]

Report
Posts
3
Registration date
Sunday September 6, 2009
Status
Member
Last seen
September 8, 2009
-
Posts
3
Registration date
Sunday September 6, 2009
Status
Member
Last seen
September 8, 2009
-
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

Posts
3
Registration date
Sunday September 6, 2009
Status
Member
Last seen
September 8, 2009
1
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month


hi there,

follow the steps on this link:

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

thanks

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!