Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    May 2003
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting (2000)

    Hello everyone,
    I am trying to set up a conditional format so that when I do an entry in cell Q3 then cells A3:P3 will change a different color. Maybe this requires a macro! Help!

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

    Re: Conditional Formatting (2000)

    You can probably do this without macros. Select A3:P3, then Format | Conditional Formatting...
    Select Formula Is from the first combo box, then enter a formula in the Formula box. For instance, if you want A3:P3 to have specific formatting if Q3 is not empty, use
    =NOT(ISEMPTY(Q3))
    Next, set the font or background color you want, and finally click OK.

  3. #3
    New Lounger
    Join Date
    May 2003
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (2000)

    Hans,
    I have tried your formula with the conditional formatting and could not get it to work. I also looked in my function list and could not find ISEMPTY.
    Thanks, Ken

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

    Re: Conditional Formatting (2000)

    Oops, sorry, wrong translation. It should have been ISBLANK. <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>

  5. #5
    New Lounger
    Join Date
    May 2003
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (2000)

    EDIT POST: Hans I was able to solve my own problem for a change!!! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> I simply modified the formula to =NOT(ISBLANK($Q$3)) and it worked beautifully!!!!! <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>
    Thanks a-lot for your help!!
    Ken


    Well Hans,
    We are very close to having what I need, when I select A3:P3 and go to Tools|Conditional Formating and select Formula Is, I put in =NOT(ISBLANK(Q3)) and A3 changes format exactly as is should but it is the only cell that changes! <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  6. #6
    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: Conditional Formatting (2000)

    <pre>=NOT(ISBLANK($Q3))</pre>


    The dollar sign will LOCK it on column Q for all the columns selected

    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
  •