Previous Topic Next Topic

Automated conditional copying

Closed
Greg - 16 Aug 2010 à 10:10
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 17 Aug 2010 à 23:50
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

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

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
System recovery on xp
niloufar -
Ambucias -

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

1 response
Conditional formatting based text in another cell
y88y -
y88y -

2 responses