Conditional formatted cell with specific colours should copy in

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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