Results 1 to 5 of 5

Conditional Formatting for Multiple Rows

Threaded View

  1. #1
    Registered User
    Join Date
    05-20-2009
    Location
    Atlanta, GA
    MS-Off Ver
    Office 365
    Posts
    60

    Conditional Formatting for Multiple Rows

    Hello again gang,

    Today my problem is with Conditional Formatting. I have a spreadsheet of a couple hundred products, their sales over the last 18 months, and then each product's 18 month average monthly sales.

    What I would like to do is format them so if any of the months' sales are below their respective average, that cell/month with be highlighted. Excel told me that I cannot do this for multiple rows at a time, and I don't want to go row by row for this many products.

    Attached is a sample file of the first row.
    Attached Files Attached Files
    Last edited by keithfender; 07-08-2009 at 10:07 AM.

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