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 LINE (2000 sr 1)

    i have this heet and i would want to insert this conditional format:
    If in the column T are present "ASS. CONT. A CDI 50" colorize enrtire line range A:X in red.
    See attached

    Bubt & Note: i have see when ai make a conditional formattiing not is possible tu copy a parameter with the tipical command CUT and PASTE, or is my Excel wrong...

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

    Re: COLORIZE LINE (2000 sr 1)

    Select A7:X24 (or as far down as you want).
    Select Format | Conditional Formatting...
    In the first dropdown, select Formula Is.
    In the box next to it, enter
    =($T7="ASS. CONT. A CDI 50")
    Click Format...
    Select Red in the Color dropdown list in the Font tab.
    Click OK twice.

    Conditional formatting will be copied too when you Cut/Copy and Paste.

  3. #3
    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 LINE (2000 sr 1)

    Select T7:X (whatever row)
    format - conditional formatting...
    "Formula is"
    <pre>=ISNUMBER(SEARCH($T7,"ASS. CONT. A CDI 50"))</pre>

    <format>
    Font(tab)
    Color (list) choose the "red"
    <ok><ok>

    Steve

  4. #4
    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 LINE (2000 sr 1)

    You beat me to it <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Mine does a "contains" which is how I interpreted:
    <hr>in the column T are present "ASS. CONT. A CDI 50" <hr>

    though you are probably correct again.

    Steve

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

    Re: COLORIZE LINE (2000 sr 1)

    Steve & Hans tks to all...

Posting Permissions

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