Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Oroville, California, Uruguay
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Color in Truncated Cells (1997)

    I would like to take the following formula and add color to the cell if the following conditions are met:

    Red <=3
    Yellow >3 <=5
    Green >5

    =SUM(IF(('GQL Test'!$Q$1:$Q$1000=A2)*(LEFT('GQL Test'!$E$1:$E$1000,2)="MP")*ISNUMBER('GQL Test'!$C$1:$C$1000)*(('GQL Test'!$C$1:$C$1000>=101)*('GQL Test'!$C$1:$C$1000<=209)+('GQL Test'!$C$1:$C$1000>=601)*('GQL Test'!$C$1:$C$1000<=699)),1))

    Please see attached

    Thanx

    Larry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Color in Truncated Cells (1997)

    What you want is called conditional formatting.
    <UL><LI>Select the cells you want to color - in your case, cells B2:B107 in the GQL Data worksheet.
    <LI>Set the fill color to green (use the Fill Color button on the Formatting toolbar.) This will be the default color.
    <LI>Select Format | Conditional Formatting...
    <LI>From the second dropdown list, select "Less than or equal to" and in the box to the right, enter 3.
    <LI>Click on "Format...".
    <LI>Set the fill pattern to red (in the Pattern tab), then click OK.
    <LI>Click "Add >>".
    <LI>From the second dropdown list, select "Less than or equal to" and in the box to the right, enter 5.
    <LI>Click on "Format...".
    <LI>Set the fill pattern to yellow (in the Pattern tab), then click OK.
    <LI>Click OK.[/list]The conditional formatting will be applied to all selected cells.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Oroville, California, Uruguay
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Color in Truncated Cells (1997)

    Thanx Hans

    Larry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •