Results 1 to 13 of 13

Conditional formatting with more than 15 rules

Threaded View

  1. #1
    Registered User
    Join Date
    02-02-2015
    Location
    Berlin, Germany
    MS-Off Ver
    MS OFFICE 2013
    Posts
    6

    Conditional formatting with more than 15 rules

    Hi everyone,

    I need some help with conditional formatting. Even though it seems simple at first, I haven't been able to find a solution to this:

    attached you will find an example of a regular excel sheet which has in reality about 20-30 columns with different conditional formattings depending on what the column is needed for.

    The issue that I have... I want the very first column to be like warning that there is a violation of the rules in any of the rest of the colums (B-S for example)

    How do I accomplish it without setting 15-20 rules for every cell in the 1st column??



    Thank you so much for your advice!!

    Attachment 457697
    Attached Files Attached Files
    Last edited by lnjkbsn; 04-25-2016 at 12:06 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting - 2 rules in 1
    By Leathermyth in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2015, 02:29 PM
  2. Conditional Formatting two rules
    By pauldaddyadams in forum Excel General
    Replies: 1
    Last Post: 11-21-2014, 11:15 AM
  3. Conditional formatting rules
    By puzzlelover22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2014, 12:45 PM
  4. [SOLVED] 2 rules for conditional formatting
    By alfgrey in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-04-2013, 10:57 AM
  5. conditional formatting rules for a cell on sheet 1 based on rules from sheet 2
    By jsard in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-15-2013, 09:22 AM
  6. What new rules do I need for Conditional Formatting?
    By ypurcaro in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-12-2013, 04:30 AM
  7. Conditional Formatting with rules
    By howcroc in forum Excel General
    Replies: 6
    Last Post: 02-04-2011, 12:01 PM

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