Hello,
I am looking VBA solution, which can fill the colours if lower line data match with upper line using alternate colourers
For example:
Row3 data match with row2 fill colour red and font white
Row4 data match with row3 fill colour green and font white
I am using conditional format formula =SI(C2=C3;1;0) for row 3 for CF red and white
I am using conditional format formula =SI(C3=C4;1;0) for row 4 for CF green and white and then copy this format to row down
But know I am getting message formatting will not save too much data so I cannot continue formatting more that 1800 rows
So please I need the VBA solution
Sample Data
Thank you all
Excel 2000
Regards,
Moti
I am looking VBA solution, which can fill the colours if lower line data match with upper line using alternate colourers
For example:
Row3 data match with row2 fill colour red and font white
Row4 data match with row3 fill colour green and font white
I am using conditional format formula =SI(C2=C3;1;0) for row 3 for CF red and white
I am using conditional format formula =SI(C3=C4;1;0) for row 4 for CF green and white and then copy this format to row down
But know I am getting message formatting will not save too much data so I cannot continue formatting more that 1800 rows
So please I need the VBA solution
Sample Data
| Book1 | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | Za1 | Za1 | Za1 | Za1 | Za1 | Za1 | Za1 | Za1 | Za1 | ||||
| 2 | A | 5 | Y | 5 | Y | A | A | 5 | 5 | ||||
| 3 | 5 | A | Y | Y | Y | 5 | A | A | Y | ||||
| 4 | 5 | A | 5 | 5 | A | A | Y | Y | A | ||||
| 5 | 5 | A | 5 | Y | Y | 5 | A | 5 | 5 | ||||
| 6 | A | 5 | A | 5 | A | 5 | 5 | A | 5 | ||||
| 7 | A | A | A | 5 | 5 | 5 | 5 | A | 5 | ||||
| 8 | Y | A | 5 | 5 | 5 | Y | A | A | A | ||||
| 9 | A | 5 | A | A | 5 | 5 | 5 | 5 | 5 | ||||
| 10 | 5 | A | A | 5 | Y | 5 | Y | 5 | 5 | ||||
| 11 | A | Y | A | 5 | 5 | A | 5 | 5 | 5 | ||||
| 12 | 5 | 5 | 5 | 5 | 5 | 5 | A | A | A | ||||
| 13 | 5 | Y | 5 | Y | A | 5 | 5 | Y | A | ||||
| 14 | 5 | A | A | 5 | 5 | Y | A | A | 5 | ||||
| 15 | 5 | A | A | 5 | 5 | Y | 5 | 5 | Y | ||||
| 16 | 5 | 5 | 5 | A | 5 | 5 | 5 | 5 | A | ||||
| 17 | A | 5 | Y | A | 5 | 5 | 5 | Y | A | ||||
| 18 | 5 | 5 | 5 | A | 5 | A | A | 5 | A | ||||
| 19 | 5 | 5 | 5 | 5 | 5 | A | A | Y | 5 | ||||
| 20 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | ||||
| 21 | 5 | Y | Y | 5 | 5 | 5 | 5 | 5 | 5 | ||||
| 22 | 5 | 5 | A | 5 | 5 | 5 | 5 | 5 | 5 | ||||
| 23 | A | A | A | 5 | 5 | 5 | A | 5 | 5 | ||||
| 24 | A | Y | 5 | 5 | Y | 5 | 5 | 5 | 5 | ||||
| 25 | 5 | A | Y | Y | 5 | 5 | 5 | Y | A | ||||
| 26 | Y | 5 | A | A | 5 | 5 | A | A | 5 | ||||
| 27 | 5 | A | 5 | Y | Y | 5 | 5 | 5 | 5 | ||||
| 28 | 5 | 5 | A | 5 | Y | Y | Y | 5 | 5 | ||||
| 29 | Y | 5 | A | 5 | A | 5 | A | 5 | 5 | ||||
| 30 | A | 5 | 5 | 5 | 5 | 5 | Y | 5 | Y | ||||
| 31 | 5 | Y | 5 | 5 | A | 5 | 5 | 5 | A | ||||
| 32 | A | 5 | 5 | 5 | 5 | A | 5 | Y | 5 | ||||
| 33 | |||||||||||||
Sheet1 | |||||||||||||
Thank you all
Excel 2000
Regards,
Moti
Last edited:
