Results 1 to 8 of 8

Conditional Formatting - Use a formular to determine which cells to format

Threaded View

  1. #1
    Registered User
    Join Date
    02-20-2013
    Location
    Manhattan, NY
    MS-Off Ver
    Excel 2010
    Posts
    5

    Conditional Formatting - Use a formular to determine which cells to format

    I am new to writing custom rules for cell formatting, so I hope I explain my self clearly. I am looking to set up a rule where based on what is in the H Column ("OS" or "OD") the appropriate cells get highlighted with a green background color. in the F column E.g OS is stated for item 1 in the H column, so the OS cells need to be highlighted with a fill color of green for item 1 (F4 and F6), for item two F7 and F9 needs to have a green background color, item 3 (F11,F13,F15,F17,F19F21), item 4 (F24,F26,F28,F30,F32,F34) etc. I want to set up a rule so this can be automatically done. Thanks and I look forward to hearing from you.
    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