Previous Topic Next Topic

Conditional formatted cell with specific colours should copy in

Closed
anand - 10 Oct 2015 à 08:50
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 11 Oct 2015 à 17:59
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.

Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
11 Oct 2015 à 17:59
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

Similar discussions

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

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

26 responses
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response
Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses