Previous Topic Next Topic

Automated conditional copying

Closed
Greg - Aug 16, 2010 at 10:10 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 17, 2010 at 11:50 PM
Hello,
I would like to copy contents (text) of cells from column A in Sheet1 to Sheet2 if for each row in Sheet1 the cell fill colour is RED in column B (I have used conditional formatting based on a selction from a list which may vary from cell to cell so the cell colour is the easier unique condition). The copied rows (cells in column A) will obviously need to be copied onto successive rows in Sheet2 and can start from A2, A1 containing a heading. I use Excel 2003.
Many thanks


1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 17, 2010 at 11:50 PM
As far as I know, you will not be able to get the information based on color that comes into picture due to conditional format. One work around would be instead of having the formula in the conditional format, have it in some column and then you can use that cell for both conditional format and copy
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
XP System Restore Recovery CD
tigercaz -
aaaa -

4 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses