Conditional formatted cell with specific colours should copy in

Closed
anand - Oct 10, 2015 at 08:50 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 11, 2015 at 05:59 PM
Hello,

i got live data from web. i had given some condition to each row if the values are higher or lower when comparing with specific cell. i had also given conditional formaating filling with red and green colour. i need to copy all the red colours and green colours in separate in new sheet. is it possible using macro or any other option. can i get solution for this.

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 11, 2015 at 05:59 PM
Formatting can be check via marco only. On alternate solution can be that if you can have column that has a formula, that is identical to your conditional formatting formula, then you can apply filter and copy to other place as u desire
0