Colouring a row depending on data entered in a column

Hi,

I'm working on spreadsheets like the example below. Basically I want the
entire row to become shaded depending on the data entered in a particular
column:

#Coach ETA Rep Dest

105 0800 Jon AIME

106 0900 Marc CMF

107 0850 Jim AIME

108 0900 Pete LYS


Basically, if either CMF or LYS show up in column 4, I want that entire row
to be shaded.

Thanks

Use conditional formatting with a formula of

=OR($D2="CMF",$D2="LYS")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gazivaldo" <Gazivaldo@discussions.microsoft.com> wrote in message
news:A2864066-ADDC-4AEC-B908-67AC10EE2C7E@microsoft.com...
> Hi,
>
> I'm working on spreadsheets like the example below. Basically I want the
> entire row to become shaded depending on the data entered in a particular
> column:
>
> #Coach ETA Rep Dest
>
> 105 0800 Jon AIME
>
> 106 0900 Marc CMF
>
> 107 0850 Jim AIME
>
> 108 0900 Pete LYS
>
>
> Basically, if either CMF or LYS show up in column 4, I want that entire
row
> to be shaded.
>
> Thanks

Brilliant. Thanks Bob. Worked a treat