Previous Topic Next Topic

Conditional formatted cell with specific colours should copy in

Closed
anand - Oct 10, 2015 at 08:50 AM
rizvisa1 Posts 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Excel - IF function with multiple words
Nick -
user -

14 responses