Results 1 to 5 of 5

Conditional Format to look in multiple cells based on another cell

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    6

    Conditional Format to look in multiple cells based on another cell

    Using Excel 2010. We have a spreadsheet to give people a quick view of errors/missing data. We download a report and then paste it in this spreadsheet daily.

    I'm using conditional formatting. I've got it down for some of the criteria we are looking for (e.g. if E2 = "1390" & F2 = RR then change color). But now I've been asked to go further with this...

    Here is what I need to do: If colum E is "1390" and columns A-D do NOT have one of these codes, "496" "428.0" "416.0" then highlight A-D.

    I've attached an example. I don't care about what color it turns. I can change that later.

    I'll need to do this for a couple other codes in column E, but if I can get some guidance on one, I should be able to get the others down.

    Thanks,
    Carolyn
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1