Colouring a row depending on data entered in a column
Use conditional formatting with a formula of
=OR($D2="CMF",$D2="LYS")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Gazivaldo" wrote in message
...
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
|