Results 1 to 7 of 7

multiple conditional format conditions changed based on another cells value?

Threaded View

atreyu55 multiple conditional format... 06-12-2009, 02:29 AM
DonkeyOte Re: multiple conditional... 06-12-2009, 02:49 AM
atreyu55 Re: multiple conditional... 06-12-2009, 03:39 AM
DonkeyOte Re: multiple conditional... 06-12-2009, 03:41 AM
atreyu55 Re: multiple conditional... 06-12-2009, 03:44 AM
DonkeyOte Re: multiple conditional... 06-12-2009, 03:47 AM
atreyu55 Re: multiple conditional... 06-12-2009, 03:56 AM
  1. #1
    Registered User
    Join Date
    01-14-2009
    Location
    southern california
    MS-Off Ver
    Excel 2007
    Posts
    23

    multiple conditional format conditions changed based on another cells value?

    A1:A6 have numeric values 1 to 6.

    I want the conditional format values to change Based on the value in Cell B2.

    If the value in B2 is "old", then I want these conditional format conditions for A1:A6. Numbers between 1-2=green text, 3-4=orange text and 5-6=red text.

    IF the value in B2 is "new" then I want the conditional format conditions in A1:A6 to change so 1=black text, 2-3=green text, 4-5=orange text and 6=red text.

    I know how to do multiple conditional formats but i have no clue how to change multiple conditions based on another cells value.

    I hope this is simple and easy to understand. Thanks in advance.
    Last edited by atreyu55; 06-12-2009 at 03:46 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