Forum Discussion
Formula and Functions
this is just an example below of what i'm looking for. I would like to be able to highlight every other circuit along with the rows associated with it. I tried conditional formatting but i don't know the formula to do this. Is it possible? The circuit numbers are always changing, and actual file is very large.
| A00100 | North | Khan | Assess | ETH1000-2338827 |
| A00101 | South | Lopez | Replace | ETH1000-2338827 |
| A00102 | Central | Cartier | Deliver | ETH1000-2338827 |
| A00103 | South | Lopez | Deliver | ETH1000-2338827 |
| A00104 | Northwest | Cartier | Deliver | ETH1000-2338827 |
| A00105 | South | Lopez | Assess | ETH1000-2338827 |
| A00106 | Central | Cartier | Assess | ETH1000-2338827 |
| A00107 | South | Lopez | Replace | ETH1000-2338827 |
| A00108 | Northwest | Burton | Deliver | ETH1000-2336622 |
| A00109 | Central | Khan | Repair | ETH1000-2336622 |
| A00110 | West | Burton | Replace | ETH1000-2336622 |
| A00111 | South | Lopez | Deliver | ETH1000-2336622 |
| A00112 | West | Burton | Assess | TH2000-23334456 |
| A00113 | Central | Michner | Assess | TH2000-23334456 |
| A00114 | Northwest | Khan | Replace | TH2000-23334456 |
| A00115 | South | Lopez | Assess | TH2000-23334456 |
| A00116 | West | Burton | Assess | TH2000-23334456 |
| A00117 | Northwest | Burton | Assess | ETH1000-9987779 |
| A00118 | Northwest | Cartier | Replace | ETH1000-9987779 |
| A00119 | Southeast | Khan | Replace | ETH1000-9987779 |
| A00120 | Central | Cartier | Repair | ETH1000-9987779 |
| A00121 | Southeast | Khan | Replace | ETH1000-9987779 |
| A00122 | Northwest | Khan | Assess | ETH1000-9987779 |
| A00123 | South | Lopez | Replace | ETH1000-9987779 |
| A00124 | Northwest | Michner | Replace | ETH1000-9987779 |
| A00125 | South | Lopez | Assess | ETH1000-5558378 |
| A00126 | Northwest | Burton | Deliver | ETH1000-5558378 |
| A00127 | South | Lopez | Deliver | ETH1000-5558378 |
| A00128 | West | Khan | Assess | ETH1000-5558378 |
| A00129 | Northwest | Michner | Deliver | ETH1000-5558378 |
| A00130 | Southwest | Cartier | Replace | ETH1000-5558378 |
| A00131 | Northwest | Khan | Assess | ETH1000-5558378 |
| A00132 | Northwest | Khan | Replace | ETH1000-4433443 |
| A00133 | West | Khan | Assess | ETH1000-4433443 |
| A00134 | West | Khan | Replace | ETH1000-4433443 |
| A00135 | Northwest | Khan | Assess | ETH1000-4433443 |
| A00136 | West | Khan | Replace | ETH1000-4433443 |
| A00137 | Southeast | Cartier | Assess | ETH1000-4433443 |
| A00138 | Northwest | Michner | Deliver | ETH1000-4433443 |
| A00139 | South | Lopez | Assess | ETH1000-4433443 |
| A00140 | Northwest | Michner | Replace | ETH1000-4433443 |
| A00141 | West | Khan | Replace | ETH1000-4433443 |
| A00142 | Northwest | Khan | Assess | ETH1000-4433443 |
| A00143 | Northwest | Burton | Assess | ETH1000-4433443 |
4 Replies
Is the attached example similar to what you are looking for?
- i'm looking for a formula to highlight all the rows associated with the same circuit #, then not highlight the next group,, then highlight the next. Everyother group of rows associated with the same circuit. Not sure if that's possible?
