Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    COLORIZE ONLY... (2000)

    Hi,

    in this sheet is present a range of DATE, G2:BN2000 my problem is:

    colorixe in font RED all date >TODAY(), and colorize in yellow the background and cell in font RED BOLD to calculate in 25% of every line:

    example:

    1) range G2:BN2 colorize G2:R2 because are >today()
    2 range G2:BN2 colorize the cell U2 because the cell is 25% of G2:BN2 (60/4=15)
    range G2:BN2 colorize the cell R2 because the cell is 25% of G2:BN2 (48/4=12)

    this condition in the range G2:BN2000 if in this range are present a many DATE

    Tks.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: COLORIZE ONLY... (2000)

    select G2:BN2000
    Format -cond format
    Formula is:
    =AND(G1<TODAY(),(COLUMN(G1)-COLUMN($G$1)+1)=($D2*0.25))
    <format> Font Tab: Color red, Style:Bold. Patterns tab: Choose 'Yellow"
    <ok><Add>
    Cell Value, less than, =TODAY()
    <format> Font Tab: Color red <OK>
    <Add>
    Formula is:
    =(COLUMN(G1)-COLUMN($G$1)+1)=($D2*0.25)
    <format> Font Tab: Style:Bold. Patterns tab: Choose 'Yellow'
    <ok><ok>

    Cond 1 will set Yellow background, red bold font if <Today and the column is "25%" column
    Cond 2 will set red font if <Today
    Cond 3 will set back yellow and bold font if column is <25%

    Order of cond 2 and 3 is immaterial, but cond 1 with the AND must be first, since the conditions are checked (in order) until a True one is found.

    Steve

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: COLORIZE ONLY... (2000)

    great wizard

  4. #4
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: COLORIZE ONLY... (2000)

    as usual difficult to translate in italian function. Like to send or attache my file with yor modification?
    gss.italy@iol.it

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: COLORIZE ONLY... (2000)

    Here it is

    Steve

Posting Permissions

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