1. |
Select your data range. |
|
Conditional formatting Box
|
2. |
On the Format menu, click "Conditional Formatting." |
3. |
Under Condition 1, select "Cell Value Is". |
4. |
In the data entry box, type”X” - (or what ever data you wish to match & Change formatting for) |
5. |
Click the Format button. In the Format Cells dialogue box, click the Patterns tab.
|
6. |
Select a colour from the pattern Dialogue, then click OK |
|
Format Box
|
|
|
7. |
Under Condition 2, select "Formula Is". |
8. |
In the data entry box, type”=MOD(ROW(),2)=0” |
9. |
Click the Format button. In the Format Cells dialogue box, click the Patterns tab.
|
|
|
10 |
Select a colour from the pattern Dialogue, then click OK |
11 |
Click OK again in the Conditional Formatting box. |
|
The formula in step 8: =MOD(ROW(),2)=0, checks whether the row number divided by 2 has a remainder of 0. If this is true, the row is coloured in. If false the row is left as it is.
The condtions are formatted in order, this means that if the first condition is met, the 2nd will not be processed. |