miskov runec
New Member
- Joined
- May 4, 2021
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Hello all,
i will be very glad if someone can help me "transport" classic conditions i created in conditional formatting into VBA .
For example i have table where in column "W" 1:500 i have text which represents type of format of cell applied on cell in column K of the respected row.
So in cell K10 i have number 8 and W10 there is "m" or "pc" or "okruh" etc.
condition is: =ISNUMBER(SEARCH("m";$W1)) format of cell is: # ##0" m" applied to range: =$K$1:$K$500 or also on $L$1:$L$500
condition is: =ISNUMBER(SEARCH("pc";$W1)) format of cell is: # ##0" pc" applied to range: =$K$1:$K$500 or also on $L$1:$L$500
and other conditions in Slovak language where format depends on number in column K for example
condition is: =AND(ISNUMBER(SEARCH("okruh";$W1));OR($K1=0;$K1>4)) format of cell is: # ##0" okruhov" applied to range: =$K$1:$K$500 or also on $L$1:$L$500
condition is: =AND(ISNUMBER(SEARCH("okruh";$W1));AND($K1>=1;$K1<=4)) format of cell is: [=1]# ##0" okruh";[<5]0" okruhy"; applied to range: =$K$1:$K$500 or also on $L$1:$L$500
Thanks for any suggestions
i will be very glad if someone can help me "transport" classic conditions i created in conditional formatting into VBA .
For example i have table where in column "W" 1:500 i have text which represents type of format of cell applied on cell in column K of the respected row.
So in cell K10 i have number 8 and W10 there is "m" or "pc" or "okruh" etc.
condition is: =ISNUMBER(SEARCH("m";$W1)) format of cell is: # ##0" m" applied to range: =$K$1:$K$500 or also on $L$1:$L$500
condition is: =ISNUMBER(SEARCH("pc";$W1)) format of cell is: # ##0" pc" applied to range: =$K$1:$K$500 or also on $L$1:$L$500
and other conditions in Slovak language where format depends on number in column K for example
condition is: =AND(ISNUMBER(SEARCH("okruh";$W1));OR($K1=0;$K1>4)) format of cell is: # ##0" okruhov" applied to range: =$K$1:$K$500 or also on $L$1:$L$500
condition is: =AND(ISNUMBER(SEARCH("okruh";$W1));AND($K1>=1;$K1<=4)) format of cell is: [=1]# ##0" okruh";[<5]0" okruhy"; applied to range: =$K$1:$K$500 or also on $L$1:$L$500
Thanks for any suggestions