Hello everyone,
I have been studying and following many sources to get the desired result but in vain. I have followed this link as well as this another link .I will give a brief description of the desired result in the attached excel sheet.
The first 3 sheets "FIRST50", "FIRST100" & "FIRST200" are the data source files and have been condtionally formatted using 4 rules given therein. i have copied here under as well:
1)=AND($B2=$C2,($B2-$D2)>10) Darkred(RBG: 192,0,0) fill in the respective row
2)=AND($C2-$B2<2,$B2<>$C2,$B2<>$D2,($B2-$D2)>20) resulting in Red(RBG: 255,0,0) fill in the respective row
3)=($B2=$D2) resulting in Green(RBG: 0,176,80) fill in the respective row
4)=AND($B2<$D2+5,$B2<>$C2,$B2<>$D2,($C2-$B2)>5) resulting in Lightgreen(RBG: 146,208,80) fill in the respective row
I have the following requirement based on color fill coming out of conditional formatting:
From sheet "FIRST50", all rows satifying conditions 1&2 to be copied to sheet "SHORT50" and all rows satisfying conditions 3&4 to be copied to sheet "LONG50"
From sheet "FIRST100", all rows satifying conditions 1&2 to be copied to sheet "SHORT100" and all rows satisfying conditions 3&4 to be copied to sheet "LONG100"
From sheet "FIRST200", all rows satifying conditions 1&2 to be copied to sheet "SHORT200" and all rows satisfying conditions 3&4 to be copied to sheet "LONG200"
As per my understanding (may be wrong !), first step will be to identify the colors as per CF and second step would be to copy and paste in intended sheets. However, I am stuck in first step itself as code given in the excel sheet gives the error as #VALUE and ?NAME. Please suggest if I need to make any changes or change the code itself.
I have been studying and following many sources to get the desired result but in vain. I have followed this link as well as this another link .I will give a brief description of the desired result in the attached excel sheet.
The first 3 sheets "FIRST50", "FIRST100" & "FIRST200" are the data source files and have been condtionally formatted using 4 rules given therein. i have copied here under as well:
1)=AND($B2=$C2,($B2-$D2)>10) Darkred(RBG: 192,0,0) fill in the respective row
2)=AND($C2-$B2<2,$B2<>$C2,$B2<>$D2,($B2-$D2)>20) resulting in Red(RBG: 255,0,0) fill in the respective row
3)=($B2=$D2) resulting in Green(RBG: 0,176,80) fill in the respective row
4)=AND($B2<$D2+5,$B2<>$C2,$B2<>$D2,($C2-$B2)>5) resulting in Lightgreen(RBG: 146,208,80) fill in the respective row
I have the following requirement based on color fill coming out of conditional formatting:
From sheet "FIRST50", all rows satifying conditions 1&2 to be copied to sheet "SHORT50" and all rows satisfying conditions 3&4 to be copied to sheet "LONG50"
From sheet "FIRST100", all rows satifying conditions 1&2 to be copied to sheet "SHORT100" and all rows satisfying conditions 3&4 to be copied to sheet "LONG100"
From sheet "FIRST200", all rows satifying conditions 1&2 to be copied to sheet "SHORT200" and all rows satisfying conditions 3&4 to be copied to sheet "LONG200"
As per my understanding (may be wrong !), first step will be to identify the colors as per CF and second step would be to copy and paste in intended sheets. However, I am stuck in first step itself as code given in the excel sheet gives the error as #VALUE and ?NAME. Please suggest if I need to make any changes or change the code itself.