Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
iris22 la Simpatie.ro
 | Femeie
22 ani
Bucuresti
cauta Barbat
32 - 63 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
Source:
For this you need a helper column next to your table. Assuming the data you want to compare is in column D and the first empty column next to your table is column M, in M2 enter the following formula (regardless if row 1 is your header):
=MOD(IF(ROW()=2;0;IF(D2=D1;M1;M1+1));2)
Fill that down as far as you need, (then hide the column if you want).
Now highlight your entire data set - this selection of cells will be the ones that get shaded in the next step.
From the Home tab, click Conditional Formatting, then New Rule.
Select Use a formula to determine which cells to format.
In "Format values where this formula is true" put =$M1=1 ---- THIS IS WRONG, SEE POST #3
Click the Format button, click the Fill tab, then choose the color you want to shade with.
You can also add multiple conditions to the formula above, eg:
=MOD(IF(ROW()=2;0;IF(AND(D2=D1;F2=F1);M1;M1+1));2)
Modificat de TRaP (acum 6 ani)
|
|
| pus acum 6 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
Also working
=INDIRECT("A"&ROW())<>INDIRECT("A"&(ROW()-1))
Source:
|
|
| pus acum 5 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
Something must be corrected in post #1
The correct formula for conditional formatting should be something like:
|
|
| pus acum 1 an |
|