use conditional formatting, setting the condition for each column cell as
select A1 then choose Conditional Formatting from the Format menu option,
Condition 1 is set to "formula is" then in the formula box to the right
=d1 = "X"
press the FORMAT button and set the format pattern RED
Repeat for cells B1 and C1, changing the formula entered to
=d1 = "Y" and =d1 = "Z" respectively.
If you now select A1 to C1 then copy down the rows as required.
"firefox" < XXXX@XXXXX.COM > wrote in