Previous Topic Next Topic

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

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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 any text
LvH -
LvH -

4 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

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

1 response
Conditional formatting with multiple rules and blank text cells
PaiviM -
PaiviM -

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

14 responses