Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
NEED MACRO FOR COLOUR BY CONDITIONAL FORMATTING
Hi, I have data in coloumn A to coloumn E. (please see below)
A B C D E 000 B10 G628 000B10G628 54 000 B10 G628 000B10G628 53 000 B10 G628 000B10G628 53 000 B10 G628 000B10G628 53 000 B10 000B10 12 000 B10 000B10 13 000 B10 000B10 12 000 B10 000B10 12 in coloumn D i have Formula which is "=A1&B1&C1" as you can see above and then I put CONDITIONAL FORMATTING in coloumn D as well in which I put the Formula which is "=IF(AND(D2=D3,E2<E3),TRUE)" its mean that if two values in coloumn D cells are equal but two values in coloumn E are not equal which are against each other in same cells then its true and the Cell should get Red colour. so when ever two values in coloumn D are equal but in next coloumn E the two values are not equal cell get Red colour by CONDITIONAL FORMATTING.I want MACRO which can copy only those rows in which coloumn D cells have Red colour to next sheet. Please Note that cells getting Red colours by CONDITIONAL FORMATTING and whole coloumn D have CONDITIONAL FORMATTING. Some friend send me macro but it copy all data to next sheet instead of just coping only those rows in which coloumn D cells have Red colour by CONDITIONAL FORMATTING. Please if anybody can help. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Row colour | Excel Discussion (Misc queries) | |||
Conditional formatting - flashing colour | Excel Discussion (Misc queries) | |||
change tab colour when using conditional formatting in a cell | Excel Worksheet Functions | |||
Interior Cell Colour - Conditional Formatting | Excel Programming | |||
Conditional formatting: Colour coding | Excel Discussion (Misc queries) |