Results 1 to 6 of 6

Conditional formatting an Excel 2003 colomn

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-13-2009
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    245

    Conditional formatting an Excel 2003 colomn

    Hello, could some one please help me with the following:

    In column P of my Excel 2003 worksheet named: Data, I need the following text in the cells to have the interior colors (as shown below):

    Any Situation - RGB = 255,204,0 (with black text);
    Apples - RGB = 153, 204, 0 (with black text);
    Apples / Rasberry = 153, 153, 255 (with black text);
    Jam = 128,0,128 (with white text);
    Nectarine = 0,0,128 (with white text);
    Nectarine / Apples = 255,255,153 (with black text);
    Nectarine / Rasberry = 255,204,153 (with black text);
    Orange = 255,153,204 (with black text);
    Rasberry = 153,204,255 (with black text); and
    Sausage = 0,0,0 (with white text).

    The range is P3:P20

    I tried using conditional formatting but it only allowed me to use three conditions.

    If any one could help, it would be greatly appreciated.

    Kind regards,

    Chris
    Last edited by longbow007; 10-26-2009 at 06:08 PM.

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