ststern45
Well-known Member
- Joined
- Sep 17, 2005
- Messages
- 974
- Office Version
- 365
- 2010
- Platform
- Windows
Excel has a limit of 3 for conditional formatting.
I would like to know if it is possible conditional format more than 3 times with VBA:
1. If cell a1 = cell range b1:b100 then format it in RED
2. If cell a1 = cell range c1:c100 then format it in Green
3. If cell a1 = cell range d1:d100 then format it in Blue
4. If cell a1 = cell range e1:e100 then format it in Yellow
Thanks for your help!!
Steve
I would like to know if it is possible conditional format more than 3 times with VBA:
1. If cell a1 = cell range b1:b100 then format it in RED
2. If cell a1 = cell range c1:c100 then format it in Green
3. If cell a1 = cell range d1:d100 then format it in Blue
4. If cell a1 = cell range e1:e100 then format it in Yellow
Thanks for your help!!
Steve