Colouring a row depending on data entered in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return to next row in first column when entering data in Excel 3
remove duplicate rows from specific data in a column; excel 2007 1
How do I copy a row depending on the content of a cell in the row 2
Static current date based on when data in another column was enter 3
FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA 7
colour of a row depending on cell value 6
Counting # of Formulas in a column with formulas and entered data 1
add data in column related to cell in another column - see full de 1

Back
Top